I have two stacked columns charts that i want to plot on the same x axis.
Say I have a stacked column chart consisting of monthly apple sales for 2005.
Each stacked column contains the number of granny smith apples and total
apples sold. I also have the same chart for 2006. How can i combined the
two charts so that i the stacked columns are next to each other for each
month? This way i can compare side by side the number of granny apples and
total apple sales for any given month. Anyone know how to do this in excel
2003?

< snip >
> Anyone know how to do this in excel 2003?

The experts in an Excel newsgroup would be able to tell you.

"yearlaw" wrote

>I have two stacked columns charts that i want to plot on the same x axis.
> Say I have a stacked column chart consisting of monthly apple sales for
> 2005.
> Each stacked column contains the number of granny smith apples and total
> apples sold. I also have the same chart for 2006. How can i combined the
> two charts so that i the stacked columns are next to each other for each
> month? This way i can compare side by side the number of granny apples
> and
> total apple sales for any given month. Anyone know how to do this in
> excel
> 2003?

One of the Excel newsgroups on the web:
http://www.microsoft.com/communities...&lang=en&cr=us

--
Rock [MVP - User/Shell]