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!

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!

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!

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!

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!

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!