Change the Chart Type in Excel 2007

by rhyttinen on October 29, 2009

Today we continue our discussion of Excel charts by learning how to change the type of chart you are using. Excel offers many different chart types to aid you in communicating different types of information. Once your chart is created, you can easily change the type of chart to a pie chart, line chart, area chart, etc. To do so, click the Change Chart Type button on the Type group under the contextual Design tab under Chart Tools to display the Chart Type dialog box. From there, you can choose from a wide array of chart types.

Change Chart Type dialog box

Change Chart Type dialog box

To Change the Chart Type:

  1. Click the chart to select it.
  2. Click the contextual Design tab under Chart Tools on the Ribbon.
  3. Click the Change Chart Type button on the Type group.
  4. Click the chart type category that you want in the left pane.
  5. Click the chart type that you want in the right pane.
  6. Click OK.

Similar Posts:

Share and Enjoy:
  • del.icio.us
  • Digg
  • TwitThis
  • Reddit
  • Technorati
  • Facebook
  • StumbleUpon
  • Google Bookmarks
  • Propeller
  • email

Leave a Comment

Previous post:

Next post: