Chart Menu Commands in Excel 2007

October 14th, 2008 Posted in Menu

Part 8 of the menu series covers the Chart menu commands in Excel 2007. The Chart Tools tab is activated only when a chart is selected. The Design, Layout and Format tabs reside underneath the Chart Tools. In previous versions of Excel, creating and editing charts seems like a black art to some. My impression with the Chart Tools interface is that this is a more approachable method for a lay person to create and edit charts.

Chart Menu

Excel 2003 Commands Equivalent Excel 2007 Commands
Chart Type Chart Tools > Design tab > Type group > Change Chart Type
Source Data Chart Tools > Design tab > Data group > Select Data
Chart Options Chart Tools > Layout tab
Locations Chart Tools > Design tab > Location group > Move Chart
Add Data Chart Tools > Design tab > Data group > Select Data
Add Trendline Chart Tools > Layout tab > Analysis group > Trendline
3-D Views Chart Tools > Layout tab > Background group > 3-D Rotation

Share and Enjoy:
  • Digg
  • del.icio.us
  • Google
  • Reddit
  • Facebook
  • StumbleUpon
  • Live
  • E-mail this story to a friend!

Tags: , , , ,

Post a Comment