Charting Stacked along with regular bar

[LIN]

Hi,

My Data is something like this:
2002 2003
Software sales 500 800
Services Sales 4000 6000
Non-IT Income 5000 3000

I am trying to graph this - I need Software Sales and Services Sales to come
in a single stacked bar while Non-IT Income as a regular bar.

I have tried using stacked chart but then all my 3 headings are stacked. If
I use a plain bar chart I get all the 3 headings besides each other for each
year.

Please advice. Thanks in advance.

LIN

 

[Nicky]

Hi LIN

The attached sheet shows one way of doing this, by running x axi
labels in 2 rows or columns

Attachment filename: stacked side by side chart.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=41701

 

[Jon Peltier]

Stagger your data:

2002 2003
Software Sales 500 800
Service Sales 4000 6000
Non-IT Income 5000 3000

Make a stacked graph with this data.
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.co.uk/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

 

[LIN]

Thanks a lot John and Nicky!!

That helped. I appreciate your help.
LIN