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.
----
Regards,
John Mansfield
http://www.pdbook.com
"Cheshire cat" wrote:
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