hybrid graph - two types in one display

  • Thread starter Thread starter michael
  • Start date Start date
M

michael

I need to creat a bar graph with one bar using only one
data source and the other bar consisting of two stacked
data sources. Can it be done?

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

And if you can make a (vertical) column chart this way, you can also
make a (horizontal) bar chart this way.

- Jon
 
Back
Top