Camparison between years

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

Guest

I'd like to show the number of units sold in Jan 02(200 ea) compared to
number of units sold in Jan 03(450 ea) to units sold in Jan 04(625 ea), on a
chart with the months clustered together(in sequence)for comparison.

Thanks for your help
 
If you set your data up like this . . . make sure the years are formatted as
text. Assume the title "Years" is in cell A2 and that this example spans the
range A1 to C10:

Years Units
Jan 02 200
03 450
04 625
Feb 02 250
03 400
04 600
Mar 02 300
03 250
04 500

Create a clustered column chart based on this setup. The chart will group
the months first and the years.
 
Back
Top