Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

How to Add a Data Table to an Excel 2007 Chart

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.

1

Click 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.

2

Click 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.

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.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!