.1. Access the Chart Data Wizard in one of two ways:
Click the Insert New Chart icon .
OR
Right-click anywhere in the view grid. From the pop-up menu, choose Insert then Chart.
2a. In the Chart Data Wizard (Step 1 of 3) - Series window, choose the chart type, whether series are from rows or columns, three dimensional, and dynamic or static. If series are dynamic, you also have the option of including Total and All Others data. See Chart Data Wizard (Step 1 of 3) – Series.
2b. If you selected series to be static, options display to select the values for the series. Click Add to open an additional selection window. See Chart Data Wizard (Step 1b of 3) – Static Series.
Highlight the rows or columns in the grid and then click Select. Verify the correct data is selected, and click Done.
3a. Click Next to define the chart’s data points. In the Chart Data Wizard (Step 2 of 3) – Data Points window, choose whether the data points are dynamic or static. If data points are dynamic, you also have the option of including Total and All Others data. See Chart Data Wizard (Step 2 of 3 ) – Data Points.
3b. If you selected data points to be static, options display to select the values for the data points. Click Add to open an additional selection window. See Chart Data Wizard (Step 2b of 3) – Static Data Points.
Highlight the rows or columns in the grid and then click Select. Verify the correct data is selected, and click Done.
4. Click Next to define the style of the chart’s title, axes, and legend.
5. Click Finish.
Note: Once the chart is created, you can further customize the chart.