Multiple Stacked Colums?

  • Thread starter Thread starter grin2000
  • Start date Start date
G

grin2000

I have 2 graphs which are stacked colums charts. They represent million
of policies per month.
The x-axis and y-axis are the same on both graphs.
I want to know if I can have instead of 2 graphs just one graph wit
both combines. So for month 1 you would have 2 colums side by sid
instead of 1.
I attached a sheet with the graphs to make it easier. THANKS,
appreciate it

Attachment filename: chart.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=58512
 
Through careful arrangement of the data in your worksheet, you can make
a stacked column chart that looks like a clustered-stacked column chart.

There is a tutorial showing this technique on Bernard Liengme's site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

which is based on the example on Stephen Bullen's web site:
http://www.bmsltd.ie/Excel/Default.htm
Go to Charting Examples, and download FunChart4.xls

The following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?scid=kb;en-ca;214119

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