Stacked Column X Axis Column Headers

[zmster2033]

Hello,

I am new to stacked column graphs and am trying to have multiple headers for each column on the X-Axis. I would like the headers for each bar WC (left bar), and EC (right bar) to be listed on the graph along with the month on the X Axis. Is there a way to do this, or would you need to add text boxes to complete this? A copy of my file is attached.

Thanks.Test File.xls

[Andy Pope]

You can have multilevel category labels.

You need to alter your data layout slightly, staggering the month names.
Then expand the category axis range to include columns A and B.

[zmster2033]

You can have multilevel category labels.

You need to alter your data layout slightly, staggering the month names.
Then expand the category axis range to include columns A and B.

Andy,

Thanks for the response. Do you know if it is possible to have lines separating the bars by month? So a monthly divide in other words?

[Andy Pope]

If you mean vertical gridlines then yes,

first you need to use 2d stacked and not 3d.
add dummy series and move to secondary axis
delete secondary vertical axis
add secondary horizontal axis and set Interval between tickmarks to 4
apply secondary major vertical gridlines