If you want to compare monthly data, then in cell:
A2 enter 2004Y
A3 enter 2005Y
B1 thru M1 enter the month names - Jan thru Dec
B2 thru M2 - put 2004's values
B3 thru M3 - put 2005's values
highlight the range and use the chart wizard...
"Jen Kulak" wrote:
I am trying to make line graph where I can compare two seperate times. I
want to have one series as 2004 and one as 2005. However, I am completely
clueless on how to do it. Help!!!
|