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

Combination Charts
 

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 ,
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

Combination Charts
 

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