Stacked Chart

[cnguyen]

Hi,

I am trying to make a bar graph using a primary and secondary axis and want my bars to appear side by side (un-stacked) but no matter what Chart Type I select the graph keeps stacking my bars Can anyone help find a solution? Thanks!

 

[Steve=True]

Hi Cnguyen,

I do not believe that Excel is stacking the data. I think it is overlapping them. Try changing your Gap Width on a series and you will see. An easy fix is to add a blank column in your data and then make the gap width as big as possible.

Steve=True

 

[cnguyen]

Hi Cnguyen,

I do not believe that Excel is stacking the data. I think it is overlapping them. Try changing your Gap Width on a series and you will see. An easy fix is to add a blank column in your data and then make the gap width as big as possible.

Steve=True

Hi Steve=True,

I have tried adding a column in my data AND changing the gap width to no avail, the only thing that occurs when I change the gap width is that one of "stacked" columns gets extremely small.

Thanks!

 

[Jon Peltier]

They are not stacked. The secondary series is in front of the primary series, and any taller primary bars appear stacked on the secondary ones.

Trying to plot bars on primary and secondary axes will only confuse the people trying to make sense of your chart.

I've written a tutorial showing a more effective way to display the data:
Column Chart with Primary and Secondary Axes

 

[Steve=True]

Hi Cnguyen,

If you are still having problems creating this chart, check out this post and video tutorial:

Stop Excel From Overlapping the Columns When Moving a Data Series to the Second Axis


Let me know if it helps.

Steve=True

 

[mole999]

two things spring to mind, it either needs to be a clustered bar chart

or

you need to set up the data on different lines so they are reported differently (can be tricky)