Microsoft Office Tutorials and References
In Depth Information
Working with a Chart Data Table
Unfortunately, you cannot apply different font formatting to individual cells or rows within the data
table. You also can’t change the number formatting. The numbers displayed in a data table always
use the same number formatting as the source data.
When you add a data table to a chart, the data table essentially replaces the axis labels on the
horizontal axis. The first row of the data table contains these labels, so losing them isn’t a major
problem. However, you will not be able to apply separate formatting to the axis labels — they will
have the same formatting as the other parts of the data table.
An exception to the behavior described in the preceding paragraph occurs with bar
charts and charts with a time-scale category axis. For these types of charts, the data
table is positioned below the chart and does not replace any axis labels.
Another potential problem with data tables occurs when they are used with embedded charts. If you
resize the chart to make it smaller, the data table may not show all the data.
Using a data table is probably best suited for charts on chart sheets. If you need to show the data
used in an embedded chart, you can do so using data in cells, which provides you with much more
flexibility in terms of formatting.