With Excel 2003’s charting feature, the possibilities of how your chart can appear are almost endless. Below are just a few of the step-by-steps commands that are available.
Changing the Chart Type
-
Double-click the chart to activate it
-
Click the Chart Type command on the Standard toolbar
-
Select a new chart type
-
Click OK
Add a Chart Title
-
Double-click the chart to activate it
-
Choose Chart: Chart Options… from the Menu bar
Figure 11. Chart Options Dialog Box – Titles Tab
3. Type a title for your chart in the Chart title box
4. Click OK
Changing the Legend Position
-
Double-click the chart to activate it
-
Choose Chart: Chart Options… from the Menu bar
-
Display the Legend tab
Figure 12. Chart Options Dialog Box - Legend Tab
4. Click the checkbox next to Show legend
5. Select a new legend position
6. Click OK
Adding Data Labels
-
Double-click the chart to activate it
-
Choose Chart: Chart Options… from the Menu bar
-
Display the Data Labels tab
Figure 13. Chart Options Dialog Box - Data Labels Tab
4. Select a data label
5. Click OK
Changing the Gridlines Display
-
Double-click the chart to activate it
-
Choose Chart: Chart Options… from the Menu bar
-
Display the Gridlines tab
Figure 14. Chart Options Dialog Box - Gridlines Tab
4. Select a new gridlines display
5. Click OK
Resizing a Chart by Dragging
-
Double-click the chart to activate it
-
Position the mouse pointer on the lower-right corner of the selected chart
-
Drag to resize the chart