Excel Data Analysis For Dummies
Book image
Explore Book Buy On Amazon

A data table just shows the plotted values in a table and adds the table to the chart. A data table might make sense for other kinds of charts, but not for pivot charts. (A data table duplicates the pivot table data that Excel creates as an intermediate step in creating the pivot chart.) Nevertheless, here's what the Data Table tab does.

When you choose the Data Table command from the Add Chart Element menu, Excel displays a menu of commands: None, With Legend Keys, No Legend Keys, and More Data Table Options. To add a data table to your chart, select the With Legend Keys or No Legend Keys command. This figure shows you what a data table looks like.

Add a data table to a chart here.
Add a data table to a chart here.

After you add a data table, Excel opens the Format Data Table pane to the window. You can use its buttons to add horizontal and vertical lines and a border to the data table. And the pane also includes a check box you use to add and remove a legend.

The Format Data Table pane lets you specify where the data table appears and how it looks.
The Format Data Table pane lets you specify where the data table appears and how it looks.

About This Article

This article is from the book:

About the book author:

Paul McFedries is a true renaissance geek. He has been a programmer, consultant, database developer, and website builder. He's also the author of more than 90 books including top sellers covering Windows, Office, and macOS.

This article can be found in the category: