Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Graphs in Excel 2007 ???
Hi, I need a line graph that I don't know how to do this - can anyone help?
Q4'03,Q1'04,Q2'04,Q3'04,Q4,04 = Series 1 Q4'04,Q1'05,Q2'05,Q3'05,Q4,05 = Series 2 Q4'05,Q1'06,Q2'06,Q3'06,Q4,06 = Series 3 Q4'06,Q1'07,Q2'07,Q3'07,Q4,07 = Series 4 Q4'07,Q1'08,Q2'08,Q3'08,Q4,08 = Series 5 Q4'08,Q1'09,Q2'09,Q3'09,Q4,09 = Series 6 and then there's totals for each of these quarters 2003-4 $1,500,797 2004-1 $2,382,062 2004-2 $3,075,434 2004-3 $3,525,677 2004-4 $4,697,594 2005-1 $2,482,163 2005-2 $4,722,111 2005-3 $4,564,459 2005-4 $9,857,116 2006-1 $5,717,634 2006-2 $8,011,175 2006-3 $3,580,349 2006-4 $10,124,599 2008-1 $5,592,601 2008-2 $11,587,096 2008-3 $7,259,220 2008-4 $11,684,795 2009-1 $3,937,246 2009-2 $6,623,390 2009-3 $5,373,417 2009-4 $5,170,567 2010-1 $2,711,538 thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Graphs in Excel 2007 ???
In general, for each series, put the X values in the first column and the Y
values in the second. For line charts, all series use the same X values, so you don't really need to specify X values for any series past the first. How do you want the quarters to show up? End to end, so the last point of one series lines up with the first point of the next? Or lines up so all the Q4 values lines up vertically? If the first, put all the Q labels in one column, then put data only in the rows of each additional column where you want data: Srs 1 Srs 2 Srs 3 Q4 03 xxx Q1 04 xxx Q2 04 xxx Q3 04 xxx Q4 04 xxx xxx Q1 05 xxx Q2 05 xxx Q3 05 xxx Q4 05 xxx Q1 06 xxx xxx etc. If it's the second: 03-04 04-05 05-06 Q4 xxx xxx xxx Q1 xxx xxx xxx Q2 xxx xxx xxx Q3 xxx xxx xxx Q4 xxx xxx xxx In either case, select the data and make your chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "HS" wrote in message ... Hi, I need a line graph that I don't know how to do this - can anyone help? Q4'03,Q1'04,Q2'04,Q3'04,Q4,04 = Series 1 Q4'04,Q1'05,Q2'05,Q3'05,Q4,05 = Series 2 Q4'05,Q1'06,Q2'06,Q3'06,Q4,06 = Series 3 Q4'06,Q1'07,Q2'07,Q3'07,Q4,07 = Series 4 Q4'07,Q1'08,Q2'08,Q3'08,Q4,08 = Series 5 Q4'08,Q1'09,Q2'09,Q3'09,Q4,09 = Series 6 and then there's totals for each of these quarters 2003-4 $1,500,797 2004-1 $2,382,062 2004-2 $3,075,434 2004-3 $3,525,677 2004-4 $4,697,594 2005-1 $2,482,163 2005-2 $4,722,111 2005-3 $4,564,459 2005-4 $9,857,116 2006-1 $5,717,634 2006-2 $8,011,175 2006-3 $3,580,349 2006-4 $10,124,599 2008-1 $5,592,601 2008-2 $11,587,096 2008-3 $7,259,220 2008-4 $11,684,795 2009-1 $3,937,246 2009-2 $6,623,390 2009-3 $5,373,417 2009-4 $5,170,567 2010-1 $2,711,538 thanks! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Graphs in Excel 2007 ???
hi, thanks for your reply
I'm looking for something like this but with each series having it's own line so they can compare each set of series I only seem to be able to do if by qtr and not by qtr put into a series so it can compare series .. sorry I'm probably using the wrong language here .. "Jon Peltier" wrote: In general, for each series, put the X values in the first column and the Y values in the second. For line charts, all series use the same X values, so you don't really need to specify X values for any series past the first. How do you want the quarters to show up? End to end, so the last point of one series lines up with the first point of the next? Or lines up so all the Q4 values lines up vertically? If the first, put all the Q labels in one column, then put data only in the rows of each additional column where you want data: Srs 1 Srs 2 Srs 3 Q4 03 xxx Q1 04 xxx Q2 04 xxx Q3 04 xxx Q4 04 xxx xxx Q1 05 xxx Q2 05 xxx Q3 05 xxx Q4 05 xxx Q1 06 xxx xxx etc. If it's the second: 03-04 04-05 05-06 Q4 xxx xxx xxx Q1 xxx xxx xxx Q2 xxx xxx xxx Q3 xxx xxx xxx Q4 xxx xxx xxx In either case, select the data and make your chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "HS" wrote in message ... Hi, I need a line graph that I don't know how to do this - can anyone help? Q4'03,Q1'04,Q2'04,Q3'04,Q4,04 = Series 1 Q4'04,Q1'05,Q2'05,Q3'05,Q4,05 = Series 2 Q4'05,Q1'06,Q2'06,Q3'06,Q4,06 = Series 3 Q4'06,Q1'07,Q2'07,Q3'07,Q4,07 = Series 4 Q4'07,Q1'08,Q2'08,Q3'08,Q4,08 = Series 5 Q4'08,Q1'09,Q2'09,Q3'09,Q4,09 = Series 6 and then there's totals for each of these quarters 2003-4 $1,500,797 2004-1 $2,382,062 2004-2 $3,075,434 2004-3 $3,525,677 2004-4 $4,697,594 2005-1 $2,482,163 2005-2 $4,722,111 2005-3 $4,564,459 2005-4 $9,857,116 2006-1 $5,717,634 2006-2 $8,011,175 2006-3 $3,580,349 2006-4 $10,124,599 2008-1 $5,592,601 2008-2 $11,587,096 2008-3 $7,259,220 2008-4 $11,684,795 2009-1 $3,937,246 2009-2 $6,623,390 2009-3 $5,373,417 2009-4 $5,170,567 2010-1 $2,711,538 thanks! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Graphs in Excel 2007 ???
If you had tried either of the cases I described, you would have gotten a
separate line for each series. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "HS" wrote in message ... hi, thanks for your reply I'm looking for something like this but with each series having it's own line so they can compare each set of series I only seem to be able to do if by qtr and not by qtr put into a series so it can compare series .. sorry I'm probably using the wrong language here .. "Jon Peltier" wrote: In general, for each series, put the X values in the first column and the Y values in the second. For line charts, all series use the same X values, so you don't really need to specify X values for any series past the first. How do you want the quarters to show up? End to end, so the last point of one series lines up with the first point of the next? Or lines up so all the Q4 values lines up vertically? If the first, put all the Q labels in one column, then put data only in the rows of each additional column where you want data: Srs 1 Srs 2 Srs 3 Q4 03 xxx Q1 04 xxx Q2 04 xxx Q3 04 xxx Q4 04 xxx xxx Q1 05 xxx Q2 05 xxx Q3 05 xxx Q4 05 xxx Q1 06 xxx xxx etc. If it's the second: 03-04 04-05 05-06 Q4 xxx xxx xxx Q1 xxx xxx xxx Q2 xxx xxx xxx Q3 xxx xxx xxx Q4 xxx xxx xxx In either case, select the data and make your chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "HS" wrote in message ... Hi, I need a line graph that I don't know how to do this - can anyone help? Q4'03,Q1'04,Q2'04,Q3'04,Q4,04 = Series 1 Q4'04,Q1'05,Q2'05,Q3'05,Q4,05 = Series 2 Q4'05,Q1'06,Q2'06,Q3'06,Q4,06 = Series 3 Q4'06,Q1'07,Q2'07,Q3'07,Q4,07 = Series 4 Q4'07,Q1'08,Q2'08,Q3'08,Q4,08 = Series 5 Q4'08,Q1'09,Q2'09,Q3'09,Q4,09 = Series 6 and then there's totals for each of these quarters 2003-4 $1,500,797 2004-1 $2,382,062 2004-2 $3,075,434 2004-3 $3,525,677 2004-4 $4,697,594 2005-1 $2,482,163 2005-2 $4,722,111 2005-3 $4,564,459 2005-4 $9,857,116 2006-1 $5,717,634 2006-2 $8,011,175 2006-3 $3,580,349 2006-4 $10,124,599 2008-1 $5,592,601 2008-2 $11,587,096 2008-3 $7,259,220 2008-4 $11,684,795 2009-1 $3,937,246 2009-2 $6,623,390 2009-3 $5,373,417 2009-4 $5,170,567 2010-1 $2,711,538 thanks! |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Graphs in Excel 2007 ???
I guess I'm confused on your first one .. and I'm guessing that's what I am
trying to do I need one line to show me 5 qtrs (4th qtr prior year and then the following 4 qtrs) and then the remaining lines to do the same thing for different years? "Jon Peltier" wrote: In general, for each series, put the X values in the first column and the Y values in the second. For line charts, all series use the same X values, so you don't really need to specify X values for any series past the first. How do you want the quarters to show up? End to end, so the last point of one series lines up with the first point of the next? Or lines up so all the Q4 values lines up vertically? If the first, put all the Q labels in one column, then put data only in the rows of each additional column where you want data: Srs 1 Srs 2 Srs 3 Q4 03 xxx Q1 04 xxx Q2 04 xxx Q3 04 xxx Q4 04 xxx xxx Q1 05 xxx Q2 05 xxx Q3 05 xxx Q4 05 xxx Q1 06 xxx xxx etc. If it's the second: 03-04 04-05 05-06 Q4 xxx xxx xxx Q1 xxx xxx xxx Q2 xxx xxx xxx Q3 xxx xxx xxx Q4 xxx xxx xxx In either case, select the data and make your chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "HS" wrote in message ... Hi, I need a line graph that I don't know how to do this - can anyone help? Q4'03,Q1'04,Q2'04,Q3'04,Q4,04 = Series 1 Q4'04,Q1'05,Q2'05,Q3'05,Q4,05 = Series 2 Q4'05,Q1'06,Q2'06,Q3'06,Q4,06 = Series 3 Q4'06,Q1'07,Q2'07,Q3'07,Q4,07 = Series 4 Q4'07,Q1'08,Q2'08,Q3'08,Q4,08 = Series 5 Q4'08,Q1'09,Q2'09,Q3'09,Q4,09 = Series 6 and then there's totals for each of these quarters 2003-4 $1,500,797 2004-1 $2,382,062 2004-2 $3,075,434 2004-3 $3,525,677 2004-4 $4,697,594 2005-1 $2,482,163 2005-2 $4,722,111 2005-3 $4,564,459 2005-4 $9,857,116 2006-1 $5,717,634 2006-2 $8,011,175 2006-3 $3,580,349 2006-4 $10,124,599 2008-1 $5,592,601 2008-2 $11,587,096 2008-3 $7,259,220 2008-4 $11,684,795 2009-1 $3,937,246 2009-2 $6,623,390 2009-3 $5,373,417 2009-4 $5,170,567 2010-1 $2,711,538 thanks! |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Graphs in Excel 2007 ???
If you want them end to end, use this data arrangement:
Srs 1 Srs 2 Srs 3 Q4 03 xxx Q1 04 xxx Q2 04 xxx Q3 04 xxx Q4 04 xxx xxx Q1 05 xxx Q2 05 xxx Q3 05 xxx Q4 05 xxx Q1 06 xxx xxx Column 1 has the quarter and year designations, column 2 has the series 1 data, column 3 has the series 2 data, etc. Select the range and make a line chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "HS" wrote in message ... I guess I'm confused on your first one .. and I'm guessing that's what I am trying to do I need one line to show me 5 qtrs (4th qtr prior year and then the following 4 qtrs) and then the remaining lines to do the same thing for different years? "Jon Peltier" wrote: In general, for each series, put the X values in the first column and the Y values in the second. For line charts, all series use the same X values, so you don't really need to specify X values for any series past the first. How do you want the quarters to show up? End to end, so the last point of one series lines up with the first point of the next? Or lines up so all the Q4 values lines up vertically? If the first, put all the Q labels in one column, then put data only in the rows of each additional column where you want data: Srs 1 Srs 2 Srs 3 Q4 03 xxx Q1 04 xxx Q2 04 xxx Q3 04 xxx Q4 04 xxx xxx Q1 05 xxx Q2 05 xxx Q3 05 xxx Q4 05 xxx Q1 06 xxx xxx etc. If it's the second: 03-04 04-05 05-06 Q4 xxx xxx xxx Q1 xxx xxx xxx Q2 xxx xxx xxx Q3 xxx xxx xxx Q4 xxx xxx xxx In either case, select the data and make your chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "HS" wrote in message ... Hi, I need a line graph that I don't know how to do this - can anyone help? Q4'03,Q1'04,Q2'04,Q3'04,Q4,04 = Series 1 Q4'04,Q1'05,Q2'05,Q3'05,Q4,05 = Series 2 Q4'05,Q1'06,Q2'06,Q3'06,Q4,06 = Series 3 Q4'06,Q1'07,Q2'07,Q3'07,Q4,07 = Series 4 Q4'07,Q1'08,Q2'08,Q3'08,Q4,08 = Series 5 Q4'08,Q1'09,Q2'09,Q3'09,Q4,09 = Series 6 and then there's totals for each of these quarters 2003-4 $1,500,797 2004-1 $2,382,062 2004-2 $3,075,434 2004-3 $3,525,677 2004-4 $4,697,594 2005-1 $2,482,163 2005-2 $4,722,111 2005-3 $4,564,459 2005-4 $9,857,116 2006-1 $5,717,634 2006-2 $8,011,175 2006-3 $3,580,349 2006-4 $10,124,599 2008-1 $5,592,601 2008-2 $11,587,096 2008-3 $7,259,220 2008-4 $11,684,795 2009-1 $3,937,246 2009-2 $6,623,390 2009-3 $5,373,417 2009-4 $5,170,567 2010-1 $2,711,538 thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line graphs in Excel 2007 | Charts and Charting in Excel | |||
best tutorials for graphs ( line of best fit) for excel | Charts and Charting in Excel | |||
Smoothing Line Graphs - Excel 2000 | Excel Discussion (Misc queries) | |||
line graphs in excel | Excel Discussion (Misc queries) | |||
line graphs in excel | Excel Worksheet Functions |