MrExcel Consulting
Your One Stop for Excel Tips & Solutions

Charting Improvements in Excel 2007


June 12, 2007

Excel 2007 offers a new charting engine:

  • Create a new - select your data and press Alt + F1
  • After creating a chart, use the 3 galleries on the Design ribbon to add broad formatting to your chart.
  • In many cases, the built-in choices on the Layout ribbon provide easy access to settings that use to be buried. For example, you can change the axis to show thousands, millions, etc.

  • Even though the popular options are on the layout ribbon, the More choice at the bottom of each menu offers additional options. For example, Trillions are in the More.