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

PowerPoint 2007: Formatting & Resizing Chart

PowerPoint 2007: Formatting & Resizing Chart

With Excel 2007’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.       Select the Chart

 

Figure 24. Change Chart Type Dialog Box

 

    2.   Click the Change Chart Type command in the Type group on the Design contextual tab

    3.       Select a new chart type

    4.       Click OK

Changing the Chart Layout

     
  1. Select the Chart
     
  2.  
  3. Click the drop-down arrow to the right of the Chart Layouts gallery in the Type group on the Design contextual tab
     
  4.  
  5. Select a new chart layout
     

Changing the Chart Style

     
  1. Select the Chart
     
  2.  
  3. Click the drop-down arrow to the right of the Chart Styles gallery in the Type group on the Design contextual tab
     
  4.  
  5. Select a new chart style
     

Changing the Chart Title Position

     
  1. Select the Chart
     
  2.  
  3. Click the Chart Title command in the Labels group on the Layout contextual tab
     
  4.  
  5. Select a new chart title position
     

Changing the Axis Title Position

     
  1. Select the Chart
     
  2.  
  3. Click the Axis Title command in the Labels group on the Layout contextual tab
     
  4.  
  5. Select a new chart axis title position
     

Changing the Legend Position

     
  1. Select the Chart
     
  2.  
  3. Click the Legend command in the Labels group on the Layout contextual tab
     
  4.  
  5. Select a new legend position
     

Changing the Data Labels Position

     
  1. Select the Chart
     
  2.  
  3. Click the Data Labels command in the Labels group on the Layout contextual tab
     
  4.  
  5. Select a new data labels position
     

Changing the Data Table Display

     
  1. Select the Chart
     
  2.  
  3. Click the Data Table command in the Labels group on the Layout contextual tab
     
  4.  
  5. Select a new data table display
     

Changing the Gridlines Display

     
  1. Select the Chart
     
  2.  
  3. Click the Gridlines command in the Axes group on the Layout contextual tab
     
  4.  
  5. Select a new gridlines display
     

Adding a Trendline

     
  1. Select the Chart
     
  2.  
  3.  Click the Trendline command in the Analysis group on the Layout contextual tab
     
  4.  
  5. Select a trendline type
     
  6.  
  7. Choose the data series to add a trendline to
     
  8.  
  9. Click OK
     

Figure 25. Trendline Dialog Box

Changing the Chart Shape Styles

     
  1. Select the Chart
     
  2.  
  3. Select a chart area from the Current Selection group on the Format contextual tab
     
  4.  
  5. Click the drop-down arrow to the right of the Shape Styles gallery in the Shape Styles group on the Format contextual tab
     
  6.  
  7. Choose a Shape Style
     

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
     

Resizing a Chart by Using the Ribbon

     
  1. Select the Chart
     
  2.  
  3. Use the up and down arrows in the Size group on the Format tab to adjust the width and height of the chart