Adding a Data Table

A data table is a copy of your source data included within the chart. Data tables are useful particularly when the chart and its underlying data are not in close proximity on the worksheet or when you intend to copy the chart to a Word or PowerPoint document. To add a data table, select the chart, click the Layout tab under Chart Tools, and then click Data Table in the Labels group. The options that appear let you choose between having and not having legend keys with your table. The difference is easier discovered than described—and, as you’ll see by experimenting, minimal in any case.

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.