• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 8. Building a Worksheet with Excel > Selecting and Editing a Chart

Selecting and Editing a Chart

When you edit a chart, you alter its features, which can include selecting data or formatting elements. For example, you might want to use different colors or patterns in a data series. To change the type of chart or any element in it, you must first select the chart or element. When you select a chart, handles (small black squares) display around the window's perimeter, and the Chart toolbar displays on screen (docked or floating). When you select a chart, all of the buttons on this toolbar become active. You can use the ScreenTip feature to display the data value and the name of any object or area on a chart. When you select an object in a chart, the name of the object appears in the Chart Objects list box on the Chart toolbar, which indicates that you can now edit the object. Editing a chart does not affect the data used to create it. You don't need to worry about updating a chart if you change data in the worksheet because Excel automatically updates the chart. You can change the data range at any time. If you want to plot more or less data in a range, you can select the data series on the worksheet and then drag the range to the chart.

Select and Edit a Chart Object

Select a chart. The Chart toolbar appears.

Position the mouse pointer over a chart object, click the object to select it.

To edit the object, double-click it, make changes, and then click OK.

Click another area of the chart, or press Esc to deselect a chart object.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint