Microsoft Office Tutorials and References
In Depth Information
Changing the Chart Options
Adding a Data Table
When you place a chart on the same worksheet as
its data, you have one advantage over placing it on
its own sheet: you can put the chart right next to
the data it represents so you can see firsthand
where the chart data comes from. But if you have
your chart on its own page, you may want to add a
Data tables appear in the form of a grid beneath
the chart and display the numeric data that makes
up the chart. They are very helpful if a reader
needs to see exact values along with a graphical
display, such as when using a 3D chart. The
following steps show you how to add a data table:
Adding a data table.
Displaying Data Labels
Another form of text you can add comes in the
form of text to the individual data markers. By
default, adding data labels shows only the value of
the data point, but you can also include the series
name and, depending on the chart style, either the
category name or the X and Y values.
Data tables are not available for pie,
scatter, bubble, radar, or surface chart types.
Click anywhere on the chart you want to
Select the chart you want to modify and
choose Chart Tools Layout>Labels>Data
Labels. A menu of data label placement
options appears. The options you see depend
on your chart style.
2. Click Chart Tools Layout>Labels>Data Table.
Options include a choice not to show a data
table, show a data table but not show a chart
legend, or to show a data table and include
the chart legend identifiers.
Easily Identify Values
3. Make a Data Table selection. A data table, as
seen in Figure 13-19, displays at the bottom
of the chart showing the actual values.
You can use Data Labels to help identify the
data series values, which are sometimes
difficult to read on the y-axis scale.
Display Formatting Options
To set data table formatting, right-click the
data table and choose Format Data Table.