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-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.