Charts with many lines
 

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!!!

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!!!

Thank you ever so much! I am going to try it out right now!

"Duke Carey" wrote:

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!!!