1-866-245-5224 sales@keystonelearning.com

Excel 2003: Format & Resize Charts

Excel 2003: Format & Resize Charts

With Excel 2003’s charting feature, the possibilities of how your chart can appear are almost endless. Below are just step-by-step for each command on the Chart contextual tabs.

Changing the Chart Type

     
  1. Right-click the Chart
     
  2.  
  3. Choose Chart Type from the Shortcut menu
     

Figure 29. Chart Type Dialog Box

   3.      Select a new chart type

   4.      Click OK



Changing the Row/Column Plotting

     
  1. Display the Chart toolbar (right-click a visible chart and choose Chart from the Shortcut menu)
     
  2.  
  3. Select the Chart
     
  4.  
  5. Click the By Row (by Column) command on the Chart toolbar
     

Changing the Chart Title and Other Labels

     
  1. Right-click the Chart
     
  2.  
  3. Choose Chart Options from the Shortcut menu
     

Figure 30. Chart Options Dialog Box

   3.      Click the Chart Title box (or other label box), type your new text

   4.      Click OK

Show/Hide the Chart Legend

     
  1. Display the Chart toolbar (right-click a visible chart and choose Chart from the Shortcut menu)
     
  2.  
  3. Select the Chart
     
  4.  
  5. Click the Legend command on the Chart toolbar
     

 Changing the Data Table Display

 

   4.      Display the Chart toolbar (right-click a visible chart and choose Chart from the Shortcut menu)

   5.      Select the Chart

   6.      Click the Data Table command on the Chart toolbar

Changing the Gridlines Display

     
  1. Right-click a displayed chart gridline and choose Format Gridlines… from the Shortcut menu

Figure 31. Format Gridlines Dialog Box

   2.      Set the gridlines setting

   3.      Click OK

 

Adding a Trendline

     
  1. Select the chart
     
  2.  
  3. Choose Chart: Add Trendline from the Menu bar
     

   3.      Select a trendline type

   4.      Choose the data series to add a trendline to

   5.      Click OK

Resizing a Chart by Dragging

     
  1. Select the Chart
     
  2.  
  3. Position the mouse pointer on the lower-right corner of the selected chart
     
  4.  
  5. Drag to resize the chart