Charting Stacked along with regular bar

  • Thread starter Thread starter LIN
  • Start date Start date
L

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
 
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
 
Back
Top