| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
| chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
| Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
| Resizing chart because of refreshing Chart Data through a query | Charts and Charting in Excel | |||
| Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel | |||
Hybrid Mode
