Archive of Mr Excel Message Board
Check out Bill's new book on Charts and
Graphs for Microsoft Office Excel 2007
Back to Charting for Excel archive index
Back to archive home
Bar chart with secondary y-axisPosted by George Hornberger on December 03, 2001 3:35 PM
I am able to create a bar chart with a secondary
y-axis, but the bars show up overlapped instead of
side-by-side. Any way around this?
Re: Bar chart with secondary y-axisPosted by Hansoh on December 04, 2001 6:49 AM
click once on the bar (any bar).
right click, choose FORMAT DATA SERIES
play around with OVERLAP and GAP WIDTH to desired result. (Rinse and Repeat).
Re: Chart with stacked bars and linesPosted by Brad O. on April 10, 2005 2:31 PM
For this to work, the checkbox for "Apply to Selection" (under options) has to be checked. It took me a while to figure this out because it is not in an obvious place.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.