Combining bar and stack charts

  • Thread starter Thread starter Andreea Rotaru
  • Start date Start date
A

Andreea Rotaru

Hi all,

Is there a way to make a combination of bar and stack charts? Thanks
in advance for your help.

Andreea
 
Hi Frank,

I took a look at the website you indicated, but I couldn't find what I
am looking for. I need to be able to make something like this:

|
|
|
|
|
|
|___
| |
| |____
|___| |
| |___ |
|___| |
| |___ |
|___|___ |________________

I know how to make this using SAS but the graphs do not look as good
as in Excel.

Andreea
 
Andreea -

Are you looking for a clustered-stacked column chart? 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 also has an example:

XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?scid=kb;en-ca;214119

- Jon
 
This is exactly what I was looking for! Thank you very much.

Andreea

************************************************************
 
Back
Top