How to Format the X-axis and Y-axis in Excel 2010 Charts
How to Edit and Format an Excel 2010 Chart
 
How to Move an Embedded Excel 2010 Chart to Its Own Chart Sheet

How to Add a Data Table to an Excel 2010 Chart

In Excel 2010, data tables display the chart values in a grid beneath the chart. They are helpful if you need to see exact values along with a graphical display, such as when using a 3-D chart. Also, they may be preferable to data labels, which can be difficult to read within some charts.

1

Click anywhere on the chart you want to add a data table to.

Data tables can be added to charts on a regular worksheet, but it isn't a common practice because the worksheet itself already displays the data.

2

On the Chart Tools Layout tab, click the Data Table button in the Labels group.

Options include None (to remove a data table), Show Data Table, and Show Data Table with Legend Keys.

3

Make a selection from the Data Table menu.

You can select More Data Table Options to see additional formatting options for data tables.

4

Click OK.

A data table showing the actual values appears at the bottom of the chart.

To remove a data table, click the Data Table command button on the Chart Tools Layout tab and select None from the drop-down menu.

blog comments powered by Disqus
How to Compare Excel 2010 Values with Sparklines
 
Formatting Excel 2010 Chart Elements
How to Enhance a 3-D Chart in Excel 2010
Getting to Know the Parts of an Excel 2010 Chart
How to Move and Resize an Embedded Excel 2010 Chart
Advertisement

Inside Dummies.com