To place a data table directly beneath an Excel chart, select the chart and choose Chart Design > Add Chart Element > Data Table, then select With Legend Keys or No Legend Keys. Excel positions this built-in table inside the chart. If you mean a separate worksheet table beside or below a chart, you’ll need to position and size the chart to match the cells instead. The steps below cover both.
What You’ll Need
- Excel for Microsoft 365 on Windows, or a version of Excel with chart editing tools.
- A chart based on data with clear category labels and series names. A built-in chart data table is available for supported chart types, including common line, area, and column charts.
- If you want a separate table aligned with the chart, the worksheet range containing that table and enough room on the sheet to position the chart.
Save a copy of your workbook first if the chart is part of a report you need to preserve. Adding or formatting a chart element is reversible, but a backup makes it easier to compare layouts.
Step-by-Step
-
Check the chart’s source data. Click the chart and review the data range on the worksheet. Ideally, the range includes a header for each series and a label for each category, such as months in the first column and sales series in the first row. Those headings help Excel label the chart and its data table. If the chart is missing labels or showing the wrong categories, select it and choose Chart Design > Select Data. In the Select Data Source window, check the Chart data range and the entries under Legend Entries (Series) and Horizontal (Category) Axis Labels. Use Switch Row/Column if the series and categories are oriented the wrong way, then select OK.
-
Select the chart itself. Click within the chart border, not a cell in its source data. The Chart Design and Format tabs should appear on the ribbon. If they do not, click the chart again. Selecting the chart first matters because the data table is a chart element, not a worksheet table you insert independently.
-
Add the built-in data table. On the ribbon, choose Chart Design > Add Chart Element > Data Table. Select With Legend Keys to show a small key beside each series name, or No Legend Keys for a simpler table. Excel places the table within the chart area, below the plotted data and category axis labels. The exact appearance depends on the chart type and the amount of data.
-
Confirm that the table matches the plotted series. Compare its row and column headings with the chart legend and axis labels. Each series should have the values you expect, in the same category order as the chart. If a series is absent or the categories are wrong, go back to Chart Design > Select Data and correct the source range or series settings. A data table displays values from the chart’s source; it does not repair incorrect source data.
-
Make room by resizing the chart. Adding a data table uses space inside the chart, so the plot area may shrink. Select the chart and drag a corner sizing handle outward to give the chart more room. Keep the pointer on a corner handle to preserve the chart’s proportions as you resize. If you only want to make the plot itself larger, click inside the chart until the plot area is selected, then adjust its handles carefully; avoid squeezing the table or axis labels.
-
Format the data table if needed. Click the data table within the chart to select it. Depending on your selection and Excel build, you can use the Format tab or right-click the selected element and choose Format Data Table to open formatting options. Make changes conservatively: readable text and clear series keys are more useful than decoration. If the table is difficult to read, make the chart larger or reduce the number of displayed categories rather than shrinking the text excessively.
-
Align a separate worksheet table with the chart, if that is what you meant. A normal range of cells is not the chart’s built-in data table and cannot be attached to the chart as a chart element. Place the range and chart on the same worksheet, then move and resize the chart so its edges line up with the relevant cell boundaries. To set precise dimensions, select the chart and use the Size controls on the Format tab. To control how it behaves when rows or columns change, right-click the chart, choose Format Chart Area, and open Size & Properties > Properties. Choose Move and size with cells, Move but don’t size with cells, or Don’t move or size with cells according to your layout.
-
Check the alignment at normal viewing size. Click a blank cell to deselect the chart and inspect the result. Check that the table is legible, the chart and any separate worksheet table line up with the intended rows or columns, and nothing is clipped when printed or exported. If the chart is part of a dashboard, check it at the zoom level and page size your readers will use.
Common Mistakes
-
Confusing a chart data table with a worksheet table. The built-in option adds values inside the chart and updates with its data. A worksheet table is a cell range with its own borders and formatting. If you need a table next to a chart, arrange the cell range and chart as separate items; choosing Data Table will not turn your cell range into a chart element.
-
Expecting to drag the built-in table independently. The chart data table is attached to the chart and positioned as part of its layout. You cannot freely move it to the left, right, or a different worksheet area while leaving the chart in place. Resize the chart or use a separate cell range if you need another arrangement.
-
Using a chart type that does not offer the option. Data Table may be unavailable for some chart types. If the command is disabled or missing, consider changing to a supported type such as a line, area, or column chart, or use a separate worksheet table. Changing chart type can alter how the data is presented, so confirm that the new chart still communicates the comparison clearly.
-
Leaving out headers or selecting the wrong source range. Excel may show generic series names or omit categories when the chart range excludes the heading cells. Check the source range in Chart Design > Select Data before trying to fix the table’s appearance.
-
Making the chart too small after adding the table. The chart can become crowded, and category labels may overlap. Avoid solving this by making all text tiny. Increase the chart’s dimensions, shorten labels where appropriate, or display fewer categories.
Tips
-
Use With Legend Keys when readers may need to match table rows to colored chart series. Choose No Legend Keys when the series labels are already obvious or the chart is compact.
-
Keep category labels consistent and concise. Long labels take up space and can make both the axis and data table hard to scan.
-
For a separate worksheet table, use the worksheet grid as your reference: position the chart edge at a row or column boundary, then adjust the chart’s size using the Format tab. A consistent row height or column width makes repeated dashboard elements easier to line up.
-
If you plan to insert or delete worksheet rows and columns, choose the chart’s cell-movement property deliberately. Move and size with cells can preserve its relationship to the grid, but it can also change the chart’s dimensions when the cells change.
-
Keep the source data and chart on a clearly structured sheet, even if the finished chart appears elsewhere. This makes it easier to update the chart without rebuilding its series.
-
For printing, check the page layout as well as the on-screen view. Select Page Layout > Print Area > Set Print Area if you need to define a specific worksheet region for printing, then use Print Preview to see whether the chart and table fit together.
Troubleshooting
The Data Table command is unavailable. Make sure the chart is selected and that it uses a chart type that supports a data table. Try a line, area, or column chart if appropriate. If the command is still unavailable, use a separate worksheet range to show the values.
The table appears, but its labels or values are wrong. Select the chart and open Chart Design > Select Data. Verify the chart range, series names, and category labels. If the data is arranged by rows rather than columns, try Switch Row/Column and check the preview before accepting the change.
The chart and table look cramped or misaligned. First enlarge the chart. If the plot area itself is too small, select it and adjust its handles. For a separate cell-based table, align the chart edge with worksheet row or column boundaries and set a suitable chart size; the built-in data table cannot be repositioned separately.
The chart shifts when worksheet cells change. Right-click the chart, choose Format Chart Area, then open Size & Properties > Properties. Select the option that matches your needs: Move and size with cells, Move but don’t size with cells, or Don’t move or size with cells. These settings affect a separate chart object’s relationship to worksheet cells, not the built-in table’s position inside the chart.
You cannot find the same ribbon commands. Click the chart to reveal its contextual tabs. In Excel for Mac, select the chart and look for the Chart Design tab; the ribbon labels are generally similar, though the layout can vary by release. In Excel for the web, chart editing options may be more limited or arranged differently. If a control is missing, open the workbook in Excel for Microsoft 365 on Windows or Mac.
Frequently Asked Questions
Can I put the built-in chart data table above the chart?
No. Excel places this chart element beneath the plotted area. If you need values above or beside the chart, use a separate worksheet range and position the chart to suit your layout.
Does the chart data table update when I change the source data?
Yes. It reflects the chart’s source data, so edits to included values or labels appear in the chart and its data table. If new rows or columns are not included, update the chart’s source range through Chart Design > Select Data.
Can I show only some of the chart’s series in the table?
The built-in table follows the chart’s plotted series rather than acting as an independently filtered worksheet range. To show a custom subset, create a separate range with the values you want and align that range with the chart.
Can I align a cell range and a chart using Excel’s Align command?
Not as if the cell range were another chart or drawing object. The range remains part of the worksheet grid. Position the chart against the grid, or use Align for two or more selectable objects, such as a chart and a text box.
Do these steps work in Excel for Mac or Excel for the web?
The basic chart-element approach is similar in Excel for Mac: select the chart and look on Chart Design for Add Chart Element and Data Table. Excel for the web can have fewer chart-formatting controls, so use the desktop app if a specific option is unavailable.
Related
- Group Dates in Excel Filters: Steps, Fixes, and Tips
- Grocery List Excel Template: Free Options and Setup
- How to Password Protect an Excel Workbook in Windows
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Box Plot in Excel: Create, Format, and Read the ChartYes. In Excel for Microsoft 365 on Windows, select your numeric data, then choose Insert > Insert Statistic…
- Excel Chart Not Plotting Zero Values? How to Fix ItExcel normally plots numeric zero values, but a zero can be hard to see: a zero-height column has…
- How to Format a Doughnut Chart in Excel for ClarityTo format a doughnut chart in Excel, select the chart and use the Chart Design tab to change…
- Pareto Chart Formula in Excel: Build It Step by StepWith categories in A2:A6 and their counts in B2:B6, enter =SUM($B$2:B2) in C2 for the running total and…
- Excel Pivot Table Sort Columns by DateYes, you can sort pivot table columns by date. The fastest way is to right-click a date column…
- How to Make Org Chart Lines in PowerPoint and Align ThemTo make org chart lines in PowerPoint, insert a SmartArt organization chart and add positions with SmartArt Design…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.