Combination Charts

I am trying to build a chart that contains stacked columns and standard
columns. I have two sets of data: 1) 2005 sales by month for 6 categories
(need for stacked chart) 2) 2006 total sales projection by month (need for
standard columns). I want to put the like monthly columns (ie: stacked
January 2005 sales, standard January 2006 sales projection) side by side for
the entire year.

I checked out the custom chart option but couldn't determine how to get to
the above. Any suggestions?

Mark

See Stephen Bullen's Funchrt4.zip at
http://www.oaltd.co.uk/excel/SBXLPage.asp#Charting

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> I am trying to build a chart that contains stacked columns and standard
> columns. I have two sets of data: 1) 2005 sales by month for 6 categories
> (need for stacked chart) 2) 2006 total sales projection by month (need for
> standard columns). I want to put the like monthly columns (ie: stacked
> January 2005 sales, standard January 2006 sales projection) side by side for
> the entire year.
>
> I checked out the custom chart option but couldn't determine how to get to
> the above. Any suggestions?
>
> Mark
>

This page has links to a few examples of clustered-stacked column charts:

http://peltiertech.com/Excel/ChartsH...sterStack.html

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

"excel_user123456" <[email protected]> wrote in
message news:[email protected]...
>I am trying to build a chart that contains stacked columns and standard
> columns. I have two sets of data: 1) 2005 sales by month for 6 categories
> (need for stacked chart) 2) 2006 total sales projection by month (need for
> standard columns). I want to put the like monthly columns (ie: stacked
> January 2005 sales, standard January 2006 sales projection) side by side
> for
> the entire year.
>
> I checked out the custom chart option but couldn't determine how to get to
> the above. Any suggestions?
>
> Mark