Bar Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

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