Line Graphs in Excel 2007 ???

[HS]

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!

 

[Jon Peltier]

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

 

[HS]

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]

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

 

[HS]

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]

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