Stacked column graph

[Pat]

I am setting up a stacked column graph. I need to show January 2007 data
next to January 2008, side by side. The data is currently set up as below:

Jan 07 Jan 08 Feb 07 Feb 08
Label data data data data
Label data data data data

The graph displays all of 2007 together then it shows all of 2008. I need
the months side by side. How do I do this?

 

[Del Cotter]

I am setting up a stacked column graph. I need to show January 2007 data
next to January 2008, side by side. The data is currently set up as below:

Jan 07 Jan 08 Feb 07 Feb 08
Label data data data data
Label data data data data

The graph displays all of 2007 together then it shows all of 2008. I need
the months side by side. How do I do this?

Excel is detecting the date nature of your column headings and
"helpfully" formatting the X axis automatically as a time scale. Either
label your columns in such a way that Excel can't tell they're dates, or
just put non-dates in temporarily. Then put the dates in after you've
created the chart.

Or, go to Chart Options.. Axes.. and change the "Category (X) axis"
radio button from "Automatic" to "Category".

MS really should have made this control part of the old "Format Axis"
dialogue, because most people never did find it where it was hidden in
"Chart Options". I don't know how Excel 2007 arranges the interface now.

 

[Jon Peltier]

What data are stacked in the chart, which on top, which on the bottom?

I suspect you need to rearrange your data, and insert spaces to stagger it,
and get the proper arrangement of columns in your chart. One of the links on
this page may be helpful:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

- Jon