merge x-axis labels

[JasmineL]

I know you can do this, but it's been a while.

I am displaying two groups of data for each month on a column graph. So, above each month label, I have two columns showing, and so on for each month. However, I cannot get the month label to center underneath both columns. The label defaults to fall underneath the left column.

Can someone tell me how to correct this?

 

[Jon Peltier]

Set up your data with months listed in column A, and the two items for each month in columns B and C. But headers above columns B and C and leave the header above A blank. Now make a clustered column chart, and the month labels will be centered beneath each month's cluster.

 

[JasmineL]

Thanks, Jon.

Do you think this will work with a stacked column graph? I need to display the data in a stacked column graph.

 

[Jon Peltier]

Stacked and clustered? In addition to a carefull arrangement of data to get the columns to appear the way you want them, you need to use a dummy series to put labels where they belong. Something like this, but along the X axis:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html