Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Camparison between years
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting months to years | Excel Worksheet Functions | |||
Years of service... | New Users to Excel | |||
Calculate months and years | Excel Discussion (Misc queries) | |||
Help with Years of Service formula.... | Excel Discussion (Misc queries) | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |