Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

The Chart Tools Format tab in Excel 2007 contains command buttons that make it easy to format chart elements you select. Excel gives you a choice of methods for selecting individual chart elements:

  • Click the element directly in the chart to select it — use the ScreenTip that appears at the mouse pointer to identify the chart object before you click to select it.

  • Click the name of the chart element on the Chart Elements drop-down list in the Current Selection group on the Format tab — Excel shows you which element is currently selected by displaying its name inside the Chart Elements combo box.

After you select an element in the chart by clicking it, you can cycle through and select the other chart elements by pressing any of the arrow keys.

You can tell when an element is selected in the chart itself because selection handles appear around it and its name appears in the Chart Elements box on the Format tab.

After you select a chart element, you can then make any of the following changes to it:

  • Format the element by selecting the appropriate command button in the Shape Styles group or by clicking the Format Selection button in the Current Selection group to open the Format dialog box for that element and use its options to make the desired changes.

  • Move the element within the chart by positioning the arrowhead pointer over the element and then dragging it around. With some elements, such as the legend, you can use the selection handles to resize or reorient the object.

  • Remove the element from the chart by pressing the Delete key.

    Use the Chart Tools Format tab to format existing chart elements.
    Use the Chart Tools Format tab to format existing chart elements.

All chart elements have shortcut menus attached to them. If you know that you want to choose a command from the shortcut menu as soon as you select a part of the chart, you can both select the object and open the shortcut menu by right-clicking the chart object.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: