MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?

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