Stacked column graph

  • Thread starter Thread starter Pat
  • Start date Start date
P

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?
 
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?
Click to expand...

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.
 
Back
Top