Learn more with dummies

Enter your email to join our mailing list for FREE content right to your inbox. Easy!

How to Add a Data Table to an Excel 2007 Chart

By Diane Koers

In Excel 2007, data tables display 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.

1Click anywhere on the chart you want to modify.

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.

72800.image1.jpg

2Click the Data Table button in the Labels group on the Chart Tools Layout tab.

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

3Make a selection from the Data Table menu.

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

72802.image3.jpg

4Click OK.

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