Microsoft Office Tutorials and References
In Depth Information
Turning Data into a Chart
● Legend This optional element functions as a key to the data series, typically
providing labels next to the color or shape used for the corresponding data series.
● Labels You can add labels beneath axes to indicate what each step along the axis
represents. On the horizontal axis in Figure 13-1, we used month abbreviations (Jan,
Feb, Mar) to show a full year’s worth of data. You can also add data labels to a data
series to indicate the actual values represented by plot points.
After you create a chart, you can change its fundamental organization, layout, style, and
location at any time. All the tools you need are on the Design tab, the first of three custom
tabs that appear under the Chart Tools heading, as shown in Figure 13-2.
Figure 13-2 Using the commands on this tab, you can change chart type, select different source
data, adjust the layout and style, and move the chart.
Once you’ve settled on the right chart type and selected the correct data, you can add or
remove elements so that the chart tells your story most effectively. The Quick Layouts
gallery (in the Chart Layouts group) is especially helpful for this task. The choices available
are specific to the chart type and subtype you’ve chosen. Each layout includes a different
arrangement of titles, legends, and other chart elements, depicted as a thumbnail graphic
that offers a rough preview of the final result. If you choose a line chart with data markers,
for example, the Quick Layout gallery includes the 12 options shown here.