Microsoft Office Tutorials and References
In Depth Information
Editing a Chart
Did You Know?
You can quickly create a default chart. Select the data you want to use
for the chart, and then press F11 to create a chart on a new sheet, or
press Alt+F1 to create an embedded chart on the active worksheet.
You can set the default chart. In the Insert Chart dialog box, click Tem-
plates, right-click the chart template you want to set as the default, and
then click Set As Default Chart.
You can quickly select a recent chart template. If you want to use a re-
cent chart template, you can quickly select a recently used chart. In the
Chart Type dialog box, click Recent ( New ! ) in the left pane, select the
chart you want to use, and then click OK.
You can edit the contents of chart text. To edit the contents of a title,
click the chart or axis title. To edit the contents of a data label, double-
click the data label. Click to place the insertion, and then make changes.
Embedded charts are beneficial. A chart sheet is beneficial when you
want to view or print a chart or PivotChart report separately from work-
sheet data or a PivotTable report.
Editing a Chart
Editing a chart means altering any of its features, from data selection to formatting ele-
ments. For example, you might want to use more effective colors or patterns in a data
series. To change a chart’s type or any element within it, you must select the chart or
element. When a chart is selected, handles are displayed around the window’s perimeter,
and chart tools become available on the Design and Format tabs and in the upper-right
corner of the selected chart (three chart buttons). The chart buttons ( New ! ) on the selected
chart include Chart Elements, Chart Styles, and Chart Filters, which provide easy access
to chart tools. The Chart Elements button ( New ! ) allows you to show or hide chart ele-
ments. The Chart Styles button ( New ! ) allows you to change the style and color of the
chart. The Chart Filters button ( New ! ) allows you to filter the data you want to display on
As the figure below illustrates, you can point to any object or area on a chart to see
what it is called. When you select an object, its name appears in the Chart Objects list box
on the Format tab, and you can then edit it. A chart consists of the following elements.