Change the Layout and Style of a Chart in Excel 2007

by rhyttinen on October 23, 2009

After creating your chart, three contextual Ribbons appear under Chart Tools when the chart is selected: Design, Layout and Format, from where you can format your chart, apply various styles and change the chart layout.

Contextual Design Ribbon in Excel

From the contextual Design Ribbon, you can apply various predefined chart layouts and chart styles as well as change the chart type and modify the existing chart data. There are a wide variety of chart styles both in 2-D and 3-D formats that you can apply from the Chart Styles group on the Ribbon. Click the More button to display a gallery of all available chart styles.

For each chart type, you can also apply a preset layout from the Chart Layouts group. Again, clicking the More button on the Chart Layouts group will display a gallery of all available layouts.

Changing the Layout and Style of a Chart in Excel 2007

  1. Click the chart to select it.
  2. To change a chart layout or style, click the contextual Design tab under Chart Tools. Make your desired selection from the Chart Layout and/or Chart Style group.
  3. Click the More button on the Chart Layout or Chart Style group to display additional layout or style thumbnails.

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: