Camparison between years

[Cheshire cat]

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

 

[John Mansfield]

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.