When you create a chart in PowerPoint, the audience sees only the visual bars, lines, or pie slices. You may need to show the exact numbers that the chart represents directly below it. Adding a data table to the chart area displays the source values in a grid without inserting a separate Excel object. This article explains how to add a data table below a chart in PowerPoint, the available formatting options, and what to do when the table does not appear as expected.
Key Takeaways: Adding a Data Table to a PowerPoint Chart
- Chart Design tab > Add Chart Element > Data Table > With Legend Keys: Adds a grid of numbers below the chart with color-coded legend markers.
- Chart Design tab > Add Chart Element > Data Table > No Legend Keys: Adds the same grid but omits the colored legend markers for a cleaner look.
- Right-click the data table > Format Data Table: Opens a pane to change fill, border, and text options for the table.
What a Data Table Does in a PowerPoint Chart
A data table is a grid that sits directly below the chart plot area. It repeats the numbers from the chart's underlying Excel worksheet. PowerPoint generates the table automatically from the chart data that you entered when you created or edited the chart. You do not need to copy and paste cells from Excel.
The data table updates when you change the chart data. If you edit the values in the PowerPoint chart data sheet, the table reflects those changes immediately. This feature works with column, bar, line, area, and stock charts. Pie charts and doughnut charts do not support data tables because they display only one data series.
Before you add a data table, confirm that your chart type supports it. Right-click the chart and select Change Chart Type. Column, bar, and line charts are safe choices. If you use a radar or surface chart, the Data Table option may be grayed out.
Steps to Add a Data Table Below a Chart
Follow these steps to insert a data table beneath any supported chart in PowerPoint 2016, 2019, 2021, or Microsoft 365.
- Select the chart
Click once on the chart object on your slide. The Chart Design and Format tabs appear on the ribbon. - Open the Add Chart Element menu
Go to the Chart Design tab. In the Chart Layouts group, click Add Chart Element. A dropdown list appears. - Choose Data Table
Hover over Data Table in the list. Two options appear: With Legend Keys and No Legend Keys. Click With Legend Keys to show the table with small color squares that match each data series. Click No Legend Keys to show numbers only. - Adjust the chart layout if needed
The data table appears below the chart. PowerPoint may shrink the chart to make room. Drag the chart border or resize the chart to give the table enough space. - Format the data table (optional)
Right-click the data table grid and select Format Data Table. The Format Data Table pane opens on the right. Change fill color, border style, or text formatting from this pane.
If you want to remove the data table later, select the chart, go to Chart Design > Add Chart Element > Data Table, and click None. The table disappears and the chart returns to its original size.
Common Mistakes When Adding a Data Table
Data table option is grayed out
The Data Table menu item may appear disabled. This happens when the chart type does not support data tables. Pie, doughnut, radar, and surface charts cannot display a data table. Change the chart type to a column, bar, line, or area chart. Right-click the chart, choose Change Chart Type, and select a supported type.
Data table shows incorrect or old numbers
The data table reads values from the chart's data sheet. If you changed the chart by dragging a data point or applying a filter, the table still shows the original worksheet values. To update the table, open the chart data sheet by right-clicking the chart and selecting Edit Data. Verify that the numbers in the sheet match what you want. The table updates automatically after you close the sheet.
Data table overlaps with chart axis labels
When the chart area is too small, the data table may overlap with the horizontal axis labels or the legend. Increase the chart height by dragging the bottom border down. You can also reduce the font size of the data table text. Right-click the data table, choose Font, and set a smaller size such as 8 pt.
Data table does not print or appears cut off
If the data table extends beyond the slide boundary, it may not print fully. Resize the chart so that the entire table fits inside the slide area. Use the View > Ruler to check the slide margins. Keep the chart and table within the white slide region.
Data table looks messy with many data series
A chart with more than five data series can produce a crowded table. Consider using the No Legend Keys option to reduce visual clutter. Alternatively, show only key data points by hiding some series. Right-click a series in the chart, select Format Data Series, and set Fill to No Fill to hide it without deleting the data.
Data Table With Legend Keys vs No Legend Keys
| Item | With Legend Keys | No Legend Keys |
|---|---|---|
| Visual markers | Small color squares next to each data series name | No markers |
| Best use case | Charts with 2-4 data series where the audience needs to match colors | Charts with many series or when the legend is already visible |
| Space required | Slightly more width due to marker columns | Compact grid |
| Readability | Easier to associate rows with chart colors | Cleaner for data-heavy slides |
You can switch between these two options at any time without losing the table. Select the chart, go to Chart Design > Add Chart Element > Data Table, and click the other option.
Now you can add a data table below any supported PowerPoint chart and format it to match your slide design. The table stays linked to the chart data, so you never have to update it manually. For a cleaner slide, try the No Legend Keys option and reduce the table font to 8 pt in the Format Data Table pane. If the table still looks crowded, consider splitting your chart into two separate charts with fewer data series each.