Microsoft Office Tutorials and References
In Depth Information
Creating a new chart
The ribbon presents a different set of options, including an Analyze tab, if the selected
chart is a PivotChart. Because PivotCharts are inextricably connected with PivotTables,
we discuss them separately in Chapter 23, “Analyzing data with PivotTable reports.” See
“Creating PivotCharts” in Chapter 23.
The buttons on the Design tab, from Add Chart Element on the left to Move Chart on
the right, focus on basic structural issues relating to your chart. You can use them, among
other tasks, to add, format, or remove titles, legends, or axes; to swap rows and columns; or
to remove particular values from the chart. The Format tab, shown next, lets you do such
things as add arrows, shapes, and descriptive text.
Notice that when a chart object is selected, Excel displays three customizing buttons next
to the upper right corner of the chart:
These buttons—Chart Elements, Chart Styles, and Chart Filters—are new in Excel 2013 and
offer some alternatives to the ribbon for common chart-formatting tasks. They’re handy,
particularly if you like to work with the ribbon out of sight. If you don’t see the buttons
when a chart object appears to be selected, click the chart again; the buttons sometimes
disappear when you move a chart, even though the chart remains selected, but they’ll
reappear when you click.