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!