Back to Charting for Excel archive indexBack 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.