Bar Chart

[Guest]

I would like to create a bar chart with the information below. I would like
the lost and sold to be shown on one bar stacked for each year. So I would
have 3 bars for Jan - 2003, 2004 and 2005 each bar showing two colors.

Any help would be appreciated.

Jan 2003
sold = 4
lost = 2

Jan 2004
sold = 6
lost = 2

Jan 2005
sold = 10
lost = 3

 

[Guest]

Set up your data like this:

A B C
Month Sold Lost
Jan03
Jan04
Jan05

HIghlight the data (including Month, etc). Select the Chart WIzard tool.
CHoose Stacked Colum chart with series in columns.

That should get you there.

Barb Reinhardt

 

[Jon Peltier]

If you also have data for February and beyond, you need to lay out the
data a little more elaborately. The links on this page will direct you
to detailed instructions:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

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