View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
oldsquid oldsquid is offline
external usenet poster
 
Posts: 13
Default 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.