Excel Chart Data Table: Can You Change Its Text?

Yes—but you generally cannot edit values by typing directly into an Excel chart’s data table. In Excel for Microsoft 365 on Windows, change the source worksheet cells or the chart’s data-selection settings to alter displayed values and labels; use chart formatting controls to change how the text looks.

What an Excel chart data table shows

A chart data table is a grid displayed as part of a chart, usually beneath the plot area. It repeats the chart’s underlying values so readers can see the numbers as well as the visual pattern. Depending on the chart and the option you choose, it can also show legend keys that connect each row or column of numbers to a series in the chart.

The grid is a chart element, not a separate worksheet range. Its contents are generated from the chart’s data source: worksheet values supply the numbers, category labels supply the headings along one dimension, and series names supply the names of the plotted data. That is why changing the source or chart settings is the dependable way to change what the table says.

It helps to distinguish changing text from formatting text. Changing a category from January to Month 1 changes the label itself. Changing the font size or color changes only its appearance. Excel handles those as separate operations.

Change the values shown in the table

To change a number in the chart data table, edit the corresponding cell in the worksheet that feeds the chart. For example, if a chart displays monthly sales and the April value is wrong, correct the April source cell. The chart and its data table should update together, provided the cell is within the chart’s source range and calculation is up to date.

To locate the chart’s source, select the chart and choose Chart Design > Select Data. The Select Data Source dialog shows the chart data range and its series. This is useful when the source is on another sheet or when you are unsure which cell supplies a value. If the chart refers to a table or a named range, edit the relevant source data rather than trying to replace the displayed number in the chart.

Select the chart, then choose Chart Design > Select Data.
Check the chart data range and the series listed in the dialog.
Find the matching source cell in the worksheet and edit its value.
Return to the chart and confirm the table and plotted series reflect the change.

If you need to include additional rows or columns, adjust the chart’s data range in the same dialog or expand the source table if the chart is based on an Excel table. A chart data table does not provide an independent place to add a new data point: the chart must first include that point in its source.

Change category labels and series names

Labels commonly come from worksheet headings. If the chart uses column A for categories and row 1 for series names, changing those heading cells usually changes the corresponding chart text as well. For instance, renaming a heading from Planned to Actual in the source data can update the series name shown in the chart legend and data table.

You can also inspect or revise the label assignments through Chart Design > Select Data. In the Select Data Source dialog, use Horizontal (Category) Axis Labels and choose Edit to select a different range of category labels. Under Legend Entries (Series), select a series and choose Edit to change its series name or the ranges used for its values and name. The exact dialog controls can vary slightly with the chart type.

When editing a series name, you can use a worksheet heading as the name source or enter a fixed name in the dialog. A cell reference is usually preferable when the label should stay synchronized with the worksheet. A fixed name can be useful for a one-off chart, but it will not automatically follow a later change to the source heading.

If Excel displays numbers such as 1, 2, and 3 instead of your intended category names, check that the category-label range includes the correct cells and that the chart’s data orientation is right. In Select Data Source, Switch Row/Column can change which data is treated as series and which is treated as categories.

Format the text without changing its wording

You can usually format the chart data table’s text as a chart element. Select the chart, then click the data table area. If a click selects the whole chart instead, click again on the table or use the chart’s selection controls to target the data table. With the intended element selected, use the Home tab’s font controls to change font, size, bold, italic, or font color. The precise controls available depend on what is selected.

For example, increasing the font size can make a table easier to read in a presentation, while choosing a font color with stronger contrast can help it stand out against the chart background. These changes do not alter the underlying cell values or labels. To return to the worksheet data, click outside the chart and select the relevant cells.

You can also control whether the table includes legend keys. Select the chart and choose Chart Design > Add Chart Element > Data Table, then choose an available option such as With Legend Keys or No Legend Keys. Available choices depend on the chart type. This changes the table’s presentation, not the series names or source data.

If you prefer a keyboard shortcut to open formatting options for a selected chart element, use Ctrl+1 on Windows. On Mac, the equivalent is generally Command+1. The pane that opens depends on the selected object, and not every text-formatting control appears in that pane; the Home tab’s font controls may be more direct for basic text styling.

Control number formats and displayed precision

A displayed value can look different from its stored value because of number formatting. A source cell might contain 0.25 but be formatted as 25%, or contain 1234.5 but display as $1,235. Check the worksheet’s source cell and its number format before assuming the chart data table has changed the underlying number.

To change the source cells’ number format, select them and use Home > Number to choose a format such as Number, Percentage, or Currency, or open the Format Cells dialog with Ctrl+1 on Windows (Command+1 on Mac). The chart data table’s displayed formatting can depend on chart type and formatting settings. If changing the source cells does not produce the display you want, select the chart data table and inspect the available formatting options for that element. Avoid relying on extra decimal places or rounding in the chart display when the exact underlying values matter.

There is an important difference between changing precision and changing a value. Formatting 2.345 to show two decimal places displays 2.35, but it does not necessarily replace the underlying value with 2.35. If the calculation itself must use a rounded number, change the source data or calculation deliberately; visual formatting alone is not a data edit.

What you cannot edit directly

The chart’s data table is not an editable miniature worksheet. You cannot normally click one of its numeric entries and type a replacement while leaving the source cell unchanged. Nor should you expect to add a row by typing below the table. The chart creates the grid from its series and categories, so changes to its contents must be made in the source data or in the chart’s data assignments.

Some chart text is also not controlled by the data table. A chart title, axis title, axis labels, legend, and data labels are separate chart elements. If you want to change text printed beside individual plotted points, you may be thinking of data labels rather than the data table. Select the relevant chart element and edit or format that element separately; changing a data-table setting will not necessarily change it.

Another common mix-up is Excel’s What-If Analysis Data Table. That feature is a worksheet calculation tool, found under Data > What-If Analysis > Data Table, rather than the grid displayed inside a chart. A What-If Analysis table contains calculated results for one or two input variables. Editing one involves its worksheet inputs and formulas, not the chart’s data-table controls.

Common problems and practical fixes

The table does not change after editing a cell: Verify that you edited a cell included in the chart’s source range. Also check whether the chart points to a different sheet, table, or range than expected.
A label is missing or incorrect: Use Select Data to inspect the category-label range or series name. A heading outside the selected range will not appear just because it is nearby.
The table option is unavailable: Data tables are not offered for every chart type. Try a compatible chart type, such as a column or line chart, and check whether the Data Table command becomes available. Changing chart type can affect the visual design, so review the result.
The table is too crowded: Reduce the number of plotted categories, enlarge the chart, or remove the data table and show only selected data labels. A data table with many series can become difficult to read even when its font is formatted.
The chart appears stale: Confirm that the source data changed and that the workbook is calculating. If the chart uses a fixed range, new rows may fall outside it; expand the range or use an Excel table as the data source.

On Excel for Mac, the same core idea applies: edit source cells or chart data assignments, and format the selected chart element. Ribbon layout and some selection behavior can differ by release. Excel for the web also supports many chart edits, but the available chart-formatting controls may be more limited than in the desktop app; open the workbook in desktop Excel if a specific data-table formatting option is missing.

When a worksheet table is a better choice

If you need text or values in a grid that can be edited independently of the chart, create an ordinary worksheet table beside the chart instead of relying on the chart’s built-in data table. A worksheet table can contain custom notes, reordered labels, extra calculated columns, or manually prepared display text without changing the chart’s plotted source. The trade-off is that it is a separate object: it will not automatically behave like the chart’s own data table unless you build and maintain that connection yourself.

For a chart intended for a report, another option is to omit the data table and add data labels only to important points. This keeps the plot less crowded while emphasizing a peak, a current result, or a comparison. Choose the chart data table when readers need to inspect many underlying values; choose labels or a separate worksheet table when selective or independently editable text matters more.

Frequently Asked Questions

Can I type directly into an Excel chart data table?
No. The chart data table is generated from the chart’s source data. Edit the corresponding worksheet cell or revise the chart’s data range or series settings instead.

How do I change the words in an Excel chart data table?
Change the source category heading or series-name cell, or use Chart Design > Select Data to assign a different label range or series name.

Can I change only the font or color?
Yes. Select the chart data table as a chart element and use the Home tab’s font controls. This changes appearance, not the text or source values.

Why does my chart data table show the wrong labels?
The chart may be using an unintended category-label range, series-name cell, or row/column orientation. Review those assignments in Chart Design > Select Data.

Is a chart data table the same as a What-If Analysis Data Table?
No. A chart data table displays the chart’s source values inside the chart. A What-If Analysis Data Table is a worksheet tool that calculates results for one or two input variables.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.