Is this chart possible?
 

Is it possible with this data to create a line chart to look something like the hand drawn one below?


year 1st QTR 2nd QTR 3rd QTR 4th QTR
Div. Value Div. Value Div. Value Div. Value
2000 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.20 $15.88
2001 $0.20 $17.41 $0.20 $18.09 $0.20 $13.33 $0.20 $16.75
2002 $0.20 $16.45 $0.18 $15.80 $0.20 $6.92 $0.06 $6.23
2003 $0.06 $2.90 $0.06 $6.60 $0.06 $6.55 $0.06 $13.22
2004 $0.06 $12.10 $0.06 $18.05 $0.06 $18.25 $0.06 $21.67
2005 $0.06 $24.11 $0.06 $22.06 $0.06 $30.98 $0.10 $36.08
2006 $0.10 $61.18 $0.10 $69.24 $0.10 $62.19 $0.13 $90.68
2007 $0.13 $106.69





Live simply...Love generously...Care deeply...Speak kindly...Leave the
rest to God.

Is this chart possible?
 

I would suggest using two charts, since the Div and Value are on completely
different scales, and the data makes it hard to use primary and secondary
scales that allow the data to be shown together clearly. You also need to
rearrange your data. Here's the Div data (view in non-proportional font),
arrange the year data similarly:

2000 2001 2002 2003 2004 2005 2006 2007
2000 Q1 0
Q2 0
Q3 0
Q4 0.2 0.2
2001 Q1 0.2
Q2 0.2
Q3 0.2
Q4 0.2 0.2
2002 Q1 0.2
Q2 0.18
Q3 0.2
Q4 0.06 0.06
2003 Q1 0.06
Q2 0.06
Q3 0.06
Q4 0.06 0.06
2004 Q1 0.06
Q2 0.06
Q3 0.06
Q4 0.06 0.06
2005 Q1 0.06
Q2 0.06
Q3 0.06
Q4 0.1 0.1
2006 Q1 0.1
Q2 0.1
Q3 0.1
Q4 0.13 0.13
2007 Q1 0.13
Q2
Q3
Q4

You don't need the column with the quarters if you don't want, I used it for
clarity. The cell(s) to the left of the years in the top row must be blank,
or Excel will have trouble parsing the range. Select the data, including the
blanks, and create a line chart. Each year will have a distinct series, so
you can easily change line colors by year.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"oldsquid" wrote in message
...
Is it possible with this data to create a line chart to look something like
the hand drawn one below?


year1st QTR2nd QTR3rd QTR4th QTR
Div.ValueDiv.ValueDiv.ValueDiv.Value
2000$0.00$0.00$0.00$0.00$0.00$0.00$0.20$15.88
2001$0.20$17.41$0.20$18.09$0.20$13.33$0.20$16.75
2002$0.20$16.45$0.18$15.80$0.20$6.92$0.06$6.23
2003$0.06$2.90$0.06$6.60$0.06$6.55$0.06$13.22
2004$0.06$12.10$0.06$18.05$0.06$18.25$0.06$21.67
2005$0.06$24.11$0.06$22.06$0.06$30.98$0.10$36.08
2006$0.10$61.18$0.10$69.24$0.10$62.19$0.13$90.68
2007$0.13$106.69





Live simply...Love generously...Care deeply...Speak kindly...Leave the
rest to God.

Is this chart possible?
 

Thank you, I never designed a spreadsheet for charting before, so this was way beyond me... Happy Easter to you and yours.
"Jon Peltier" wrote in message ...
I would suggest using two charts, since the Div and Value are on completely
different scales, and the data makes it hard to use primary and secondary
scales that allow the data to be shown together clearly. You also need to
rearrange your data. Here's the Div data (view in non-proportional font),
arrange the year data similarly:

2000 2001 2002 2003 2004 2005 2006 2007
2000 Q1 0
Q2 0
Q3 0
Q4 0.2 0.2
2001 Q1 0.2
Q2 0.2
Q3 0.2
Q4 0.2 0.2
2002 Q1 0.2
Q2 0.18
Q3 0.2
Q4 0.06 0.06
2003 Q1 0.06
Q2 0.06
Q3 0.06
Q4 0.06 0.06
2004 Q1 0.06
Q2 0.06
Q3 0.06
Q4 0.06 0.06
2005 Q1 0.06
Q2 0.06
Q3 0.06
Q4 0.1 0.1
2006 Q1 0.1
Q2 0.1
Q3 0.1
Q4 0.13 0.13
2007 Q1 0.13
Q2
Q3
Q4

You don't need the column with the quarters if you don't want, I used it for
clarity. The cell(s) to the left of the years in the top row must be blank,
or Excel will have trouble parsing the range. Select the data, including the
blanks, and create a line chart. Each year will have a distinct series, so
you can easily change line colors by year.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"oldsquid" wrote in message
...
Is it possible with this data to create a line chart to look something like
the hand drawn one below?


year1st QTR2nd QTR3rd QTR4th QTR
Div.ValueDiv.ValueDiv.ValueDiv.Value
2000$0.00$0.00$0.00$0.00$0.00$0.00$0.20$15.88
2001$0.20$17.41$0.20$18.09$0.20$13.33$0.20$16.75
2002$0.20$16.45$0.18$15.80$0.20$6.92$0.06$6.23
2003$0.06$2.90$0.06$6.60$0.06$6.55$0.06$13.22
2004$0.06$12.10$0.06$18.05$0.06$18.25$0.06$21.67
2005$0.06$24.11$0.06$22.06$0.06$30.98$0.10$36.08
2006$0.10$61.18$0.10$69.24$0.10$62.19$0.13$90.68
2007$0.13$106.69





Live simply...Love generously...Care deeply...Speak kindly...Leave the
rest to God.