| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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!!! |
|
#2
|
|||
|
|||
|
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!!! |
|
#3
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lines on bar charts | Charts and Charting in Excel | |||
| linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
| Can't create dynamic charts | Charts and Charting in Excel | |||
| How to force continuous lines in line charts | Charts and Charting in Excel | |||
| Problem drawing lines on charts | Charts and Charting in Excel | |||
Linear Mode
