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, if your chart doesn't already have one, 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.