How to Fix a Chart in Excel: Common Problems and Steps

To fix a chart in Excel, select it and check its source range, chart type, and formatting in the Chart Design and Format tabs. Correct the setting that is causing the problem, then check the chart against the worksheet data. These steps are for Microsoft Excel for Microsoft 365 on Windows; the ribbon names are generally similar on Mac, while Excel for the web may offer fewer editing options.

What You’ll Need

An Excel workbook containing the chart and its source data. If you received the file from someone else, save a copy before making changes.
A clear idea of what looks wrong: for example, missing bars, incorrect labels, dates in the wrong order, or a chart that does not update.
Permission to edit the workbook. A protected sheet or read-only file may prevent changes to the chart or its data.

Step-by-Step

Select the chart and identify the issue. Click the chart’s outer border so the whole chart is selected, rather than an individual bar, label, or axis. Excel displays the contextual Chart Design and Format tabs when a chart is selected. First compare the chart with the worksheet: check which rows and columns should appear, what the series represent, and whether the labels and values match. Identifying one specific problem at a time makes it easier to avoid changing settings that are already correct.
Check the chart’s source range. Go to Chart Design > Select Data. In the Select Data Source window, inspect the Chart data range box and the listed series and category labels. If a row, column, or newly added set of data is missing, edit the range so it covers the intended cells, including the header cells where appropriate. You can also select a series and choose Edit to check its series name and values, or adjust the category-axis label range. Click OK and see whether the chart now reflects the correct cells.
Include new rows or columns that were added later. A chart based on a fixed range may not automatically include data entered beyond its original boundary. In Chart Design > Select Data, extend the chart data range to include the new cells. Check that you have not included unrelated totals, blank columns, or notes. For data that will grow regularly, consider converting the source range to an Excel table: select a cell in the data and choose Insert > Table, confirm whether the table has headers, then build or update the chart using the table data. Charts based on tables can include added table rows more conveniently, but verify the resulting chart after changing the source.
Correct the series and category orientation. If the chart shows one bar for every month when you expected one series per product, or the legend lists dates instead of product names, choose Chart Design > Switch Row/Column. This changes whether Excel interprets each row or each column as a separate series. If the result is still wrong, return to Select Data and inspect the series names, series values, and horizontal axis labels individually. Each series should point to the intended numeric values, and its name should usually refer to a meaningful header cell.
Choose a chart type that fits the data. Select Chart Design > Change Chart Type and pick a suitable type. Column or bar charts work well for comparing categories; line charts suit values tracked across an ordered sequence such as time; and scatter charts are useful when both axes are numeric measurements. A pie chart is most readable with a small number of categories that make up one whole. If you choose a type that expects a different kind of data, the chart can look misleading even when the source range is correct. For example, a line chart may treat text labels as categories, while a scatter chart requires numeric x-values.
Fix the axes and their labels. Click the axis that is wrong, right-click it, and choose Format Axis. In the formatting pane, check options such as bounds, units, number format, and label position. On a value axis, an unexpected minimum or maximum can make differences look exaggerated or flatten the data; use appropriate bounds and units for the purpose of the chart. For dates displayed as serial numbers or in an odd order, check whether the source cells contain real Excel dates rather than text, and review the axis type and number format. Do not force numeric bounds on a category axis; its options differ from those for a value axis.
Restore useful titles, legends, and data labels. Select the chart, then use Chart Design > Add Chart Element to add or adjust a chart title, axis titles, legend, data labels, gridlines, or other supported elements. Replace a generic title with one that explains what the values show. If labels display the wrong numbers or overlap, right-click a label and choose Format Data Labels to review whether the label shows a value, category name, or series name. Remove unnecessary labels or move them to a clearer position rather than shrinking the chart until the text becomes hard to read.
Check chart filters and hidden data. Some charts have a Chart Filters button, shown as a funnel icon beside the selected chart. Open it and make sure the required series and categories are checked, then apply the changes. If worksheet rows or columns are hidden, go to Chart Design > Select Data, choose Hidden and Empty Cells, and inspect whether data in hidden rows and columns should be shown. The available options depend on the chart and data. Also check for filtered worksheet rows: hiding a value from view does not always mean it should be excluded from the chart, so decide which behavior you want.
Refresh a PivotChart or a chart driven by changing data. If the chart is a PivotChart, click its related PivotTable and use PivotTable Analyze > Refresh, or use Data > Refresh All to refresh workbook connections and related data. A standard chart that refers to formulas should update when those formulas recalculate, but a chart connected to an external source may need its connection refreshed. If the source cells have changed but the chart has not, check that the chart still points to those cells and that calculation or data refresh is not paused. Save the workbook and reopen it if you need to check whether the update persists.

Common Mistakes

Changing the chart type before checking the source. A wrong range or reversed series can make a correct chart type look broken. Check the selected data first, then decide whether the chart type needs to change.

Selecting only part of the chart. Clicking a bar or label selects that chart element, so commands may format just that item rather than the complete chart. Click the chart’s border to select the full chart before using chart-wide commands.

Including totals or headings as data. A total row can distort a chart, and an extra text column can appear as an unexpected category or series. In Select Data, verify the exact cells assigned to each series and label range.

Using blank cells or text in a numeric series without checking them. A number stored as text may be treated differently from a numeric value, and blanks can create gaps. Check the source cells and their number formats, and decide whether gaps should remain visible rather than inserting arbitrary zeros.

Formatting for appearance before checking accuracy. Changing colors, axis bounds, or labels can make a chart look polished without fixing its underlying data. Confirm the chart’s meaning and values before final styling.

Tips

Keep the source data in a simple layout: one header row, one category column, and one column for each numeric series. Avoid merged cells, blank rows inside the dataset, and explanatory notes mixed into the chart range. A tidy source makes it easier to inspect the range and switch between chart types.

Make changes in small steps. After adjusting the source range, look at the chart before changing axes or labels. If a fix makes the chart worse, use Ctrl+Z on Windows to undo it immediately; on Mac, use Command+Z. Undo may not be available after some actions, such as closing the workbook, so saving a separate copy is a safer way to preserve the original.

Use descriptive worksheet headers because Excel often uses them for series names and chart labels. For a chart intended for a report, add a clear title, label units where needed, and check that colors and text remain readable at the size where the chart will be viewed or printed. Avoid relying on color alone to distinguish important series.

When sharing a workbook, check that the chart is not covering important cells and that the source data remains available to other editors. If you only need to show the finished chart, a copied picture may preserve its appearance, but it will no longer update when the source data changes.

Troubleshooting

The chart is blank. Open Chart Design > Select Data and confirm that the range contains cells with usable values. Check for a chart filter that has removed every series, hidden source rows, blank formula results, or errors in the source cells. If the chart is based on external data or a PivotTable, refresh the connection or PivotTable. If the worksheet itself is protected, you may need to unprotect it or ask the workbook owner for editing access.

The chart shows the wrong labels or series names. In Select Data, check the Horizontal (Category) Axis Labels range and each series name. Make sure the header cells are included where intended and that the label range has the same number of entries as the plotted values. If Excel has interpreted rows as series but you wanted columns, try Switch Row/Column.

Values are missing or the line has gaps. Inspect the source cells for blanks, text, or errors such as #N/A. If formulas produce empty strings, Excel may not plot them as ordinary numbers. In Select Data > Hidden and Empty Cells, review how empty cells should appear; for a line chart, the option to connect data points can bridge gaps, but it may imply continuity that the data does not support. Correct the source where possible and choose a display that does not misrepresent missing measurements.

The chart looks compressed or misleading. Review the value-axis bounds and units in Format Axis, and check whether an unusually large value or an unwanted total is included. If you adjust the axis minimum, consider whether readers could misunderstand the scale. Also check that the chart has enough room for labels and that the chosen chart type suits the number and shape of the data.

The ribbon options are missing or unavailable. Click the chart border again to select the chart, rather than a worksheet cell. On a Mac, the contextual chart tabs appear after selecting the chart; the labels can differ slightly by Excel release. In Excel for the web, select the chart and use the available chart tabs or pane, but some advanced formatting controls may be limited. If the workbook is in a format that restricts editing, save a working copy as an Excel workbook (.xlsx) if appropriate and permitted.

Frequently Asked Questions

How do I change the data a chart uses in Excel?
Select the chart, choose Chart Design > Select Data, and update the chart data range or edit a series. Confirm that the category labels and values cover the intended cells, then select OK.

Why does my Excel chart not include new rows?
The chart may use a fixed source range that stops before the new rows. Extend the range in Select Data, or use a table as the data source if the dataset will keep growing. Confirm that the new rows are part of the table and appear in the chart afterward.

How do I switch rows and columns in an Excel chart?
Select the chart and choose Chart Design > Switch Row/Column. This changes which direction Excel reads as separate series. If labels remain incorrect, inspect the series and category ranges in Select Data.

How can I fix dates that appear in the wrong order?
Check that the source values are genuine Excel dates, not text that only looks like dates. Then select the horizontal axis, choose Format Axis, and review its axis type and number format. Sorting the source data into the desired chronological order may also be necessary, depending on the chart type.

Can I repair a chart without changing its source data?
Yes. You can change its chart type, axis scale, labels, legend, colors, or other formatting without editing the worksheet values. However, if the chart points to the wrong cells or the source contains incorrect values, formatting alone will not correct the underlying information.

Why does a chart change when I filter the worksheet?
Some charts respond to filtered or hidden rows, depending on their settings and source. Check Chart Design > Select Data > Hidden and Empty Cells and, if present, the Chart Filters button. Choose whether the chart should reflect the visible data or continue to show hidden source values.

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.