On Fri, 25 Jan 2008, in microsoft.public.excel.charting,
Pat said:

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.