Percentage Over Time

[clctechnology]

After trying for an hour perhaps a better use of my time is to ask for help. How do I get the chart in Excel to give me the date across the bottom and the percentage up the left side with a line going across the dates so I can see the trend?

<table x:str="" style="border-collapse: collapse; width: 96pt;" width="128" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" x:num="" width="64" align="right" height="17">2002</td> <td class="xl22" style="width: 48pt;" x:num="0.04" width="64" align="right">4%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">2003</td> <td class="xl22" x:num="0.07" align="right">7%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">2004</td> <td class="xl22" x:num="0.23" align="right">23%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">2005</td> <td class="xl22" x:num="0.34" align="right">34%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">2006</td> <td class="xl22" x:num="0.38" align="right">38%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">2007</td> <td class="xl22" x:num="0.69" align="right">69%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">2008</td> <td class="xl22" x:num="0.92" align="right">92%</td> </tr> </tbody></table>

 

[Weaver]

Which version of XL are you using?

 

[Weaver]

If the dates are numbers, use a scatter

 

[VoG]

You can select the data and insert a Scatter chart. Then right click a data point > Format Data Series and select a line style.

 

[mgirvin]

Dear clctechnology,

In Excel 2003:

1) Highlight data
2) Go to Chart Wizard
3) Step 1; Select Line Chart
4) Step 2: click on Series Tab, Remove Series 1, Click in Category X axis Labels, Select Year Labels
5) Click Finish

In Excel 2007:

1) Highlight data
2) Go to Insert Ribbon, Chart group, Line Chart
3) Then click on the context sensitive ChartTools – Design Ribbon
4) Click on Select Data button in the Data group
5) Remove Series 1
6) Click Edit for axis labels and select the years data

The trick is that Excel thought the year data was data for another line, and so you have to tell it that they are not.

You could also enter your year data with a leading apostrophe and then Excel won’t get confused (Excel will think they are labels)

 

[clctechnology]

Thank you all very much! All method worked, and Mr. Girvin's was the one that I will use from now on. Again, we really appreciate Mr. Excel and all you folks who help us.