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!