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?



--
Pat

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.

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/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Pat" wrote in message
...
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?



--
Pat