Archive of Mr Excel Message Board

Check out our Excel Charting Resources
Back to Charting for Excel archive index
Back to archive home

Bar chart with secondary y-axis

Posted 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-axis

Posted 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 lines

Posted 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
All contents © 1998-2004
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.