1. Select the range L9:N14 by clicking cell L9, holding the mouse button and dragging down and to the right to cell N14.
2. With the cell range highlighted, click the ChartWizard button on the toolbar above the worksheet. You will notice the cursor change to a crosshairs with a small chart.
3. Position the cursor on the worksheet where you want to place the chart and click the mouse. The ChartWizard dialog box appears.
4. You've already selected the range you want to chart, so click Next >.
5. As the type of chart, select Line and click Next >.
6. Select the angular line style with no data points as the format of the line chart and click Next >. Note that at any step you can click < Back and repeat previous steps.
7. The ChartWizard displays a sample line chart using your data. However, there is one small problem. Notice the box that reads: Use First 0 columns for Category (X) Axis Labels. In our illustration, the first column (years) is the label for the X Axis, so you want to enter 1 in this box. To do so, you can either overwrite the 0 that is in the box or click the up arrow to cycle the counter to 1. After doing so, you will notice the chart change automatically to a better representation of the chart in the illustration above. Click Next >.
8. The next step allows us to add a legend and define titles to the chart, as well as each axis. After specifying titles if you wish, click Finish.

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books