Excel Chart Not Displaying Data Correctly? How to Fix

If an Excel chart is skipping, mislabeling, or mis-scaling data, select the chart and check Chart Design > Select Data first: confirm the chart’s source range, series, and category labels. Then check chart filters, hidden rows or columns, cell values, axis bounds, and chart type; one of these is often responsible for a chart that looks wrong even though the worksheet appears correct.

Start by checking the chart’s source range

A chart displays only the cells included in its source data. Select the chart, choose Chart Design > Select Data, and inspect the Chart data range box. In the same dialog, review the Legend Entries (Series) and Horizontal (Category) Axis Labels sections. The range should include the intended headers and data, without unrelated totals or blank columns.

For example, suppose a worksheet has months in A2:A13, sales in B2:B13, and a grand total in B14. If the chart’s range ends at row 11, December and November will be missing. If it includes row 14, the total may appear as a misleading extra point. Edit the range or the individual series so the chart uses the month labels and the twelve monthly values only. The exact range depends on where your data is located.

Also check whether a series uses the correct cells. In Select Data, select a series and choose Edit to review its series name and values. A series accidentally pointed at a header, a neighboring column, or a range shifted by one row can create an unexpected point or label. If the data range is spread across nonadjacent cells, verify each series separately rather than assuming Excel inferred every selection correctly.

Check whether Excel plotted rows and columns the right way

Excel guesses how a selected block should be organized. If each row is a separate category and each column is a series, the guess may be right; if your table is arranged the other way around, the chart can show one point per series or use names as values. Select the chart and choose Chart Design > Switch Row/Column. This changes the interpretation of the selected data, not the worksheet itself.

Use the legend and axis labels as clues. If you expect three lines for three products but see one line with product names along the horizontal axis, Excel may be treating rows and columns in reverse. Switching orientation may fix it immediately. If not, use Select Data to set the series and category labels explicitly. This is particularly useful with a small table, where a single header row or column can strongly influence Excel’s automatic choice.

Look for chart filters and hidden data

A chart can omit values without removing them from the worksheet. Select the chart and look for the Chart Filters button, usually shown as a funnel beside the chart. Open it and check both the series and categories. A cleared checkbox can hide a product, month, or other category from the chart while leaving the source cells untouched. Choose the items you want and select Apply.

Rows or columns hidden on the worksheet can also be excluded. In Chart Design > Select Data, choose Hidden and Empty Cells, then check Show data in hidden rows and columns if the chart should include those values. The same dialog lets you decide how empty cells appear: as gaps, zeroes, or connected data points. A gap can be appropriate when a measurement is genuinely missing; connecting across it can imply continuity that the data does not support.

Filtering a worksheet table is not exactly the same as using the chart’s own filters. Depending on the chart and its settings, filtered or hidden source rows may not appear. When the chart must reflect a particular filtered view, inspect its hidden-data setting and test the result after applying the worksheet filter. Do not assume that hiding a row deletes its value or that it will always be excluded from every chart.

Make sure the source cells contain usable values

Numbers that look numeric may actually be stored as text. This can happen after importing a CSV, copying values from a web page, or using inconsistent decimal and thousands separators. Text values may be ignored or plotted unexpectedly, especially in a value series. Check a suspicious cell by selecting it and looking at the formula bar and number format; also compare its alignment or test whether Excel recognizes it as a number. Correct the source data rather than trying to disguise the issue with chart formatting.

Dates can cause a similar mismatch. A date stored as text may be treated as a category label instead of a real date, leading to uneven spacing or odd ordering. Confirm that Excel recognizes the cell as a date by changing its number format and checking whether it displays as a date in another format. If the source contains dates as text, convert them to actual Excel date values before relying on a date axis.

Check for blanks, errors, and formulas returning an empty string. A formula that displays an empty-looking result may not behave exactly like a truly empty cell in every chart setup. Error values such as #N/A can also affect plotted points, while zero is a real value and may pull a line or column down to the baseline. Decide whether the value is missing, genuinely zero, or invalid, then represent it consistently in the source and choose the appropriate empty-cell treatment.

Review the axis scale and chart type

The data may be present but hard to see because the axis scale is misleading. Right-click the value axis and choose Format Axis. Under Axis Options, review the Minimum and Maximum bounds. If either is fixed at an unsuitable value, Excel will not automatically rescale the chart as data changes. Set the bounds back to Auto when appropriate, or choose deliberate limits when a consistent comparison across charts matters.

Axis choices can also make real differences look tiny or exaggerate small ones. A column chart whose value axis starts above zero can make modest changes appear dramatic. A secondary axis can help when two series have very different units or magnitudes, but it can also make relationships look stronger or weaker depending on the scales. Identify both axes clearly and explain the units rather than relying on appearance alone. For most ordinary comparisons of amounts, start with one axis and a scale that makes the values interpretable.

Choose a chart type that fits the data. A Line chart treats horizontal positions as categories, which is useful for equally spaced labels such as months. A Scatter chart uses numeric x-values and spaces points according to their actual values, which is usually better for measurements such as time elapsed or temperature. If dates or numbers appear in an unexpected order, check whether the current chart type is treating them as labels or numeric coordinates. Select the chart, then use Chart Design > Change Chart Type to choose a suitable type.

Check for stale ranges, formulas, and recalculation

A chart based on an ordinary cell range may not automatically include new rows added below that range. In Select Data, confirm whether the source range extends through the new values. For data that grows regularly, formatting it as an Excel table can make expansion easier: select the data, choose Insert > Table, confirm whether the table has headers, and base the chart on the table. When you add rows directly to the table, its range expands; still verify the chart if new data does not appear as expected.

If the plotted values come from formulas, the chart reflects the formula results, not necessarily the inputs you intended. Check a few source cells directly and make sure calculation is set to Automatic under Formulas > Calculation Options. In Manual mode, formulas may not update until recalculated, leaving the chart based on old results. On Windows, F9 recalculates open workbooks; on Mac, the key may require Fn depending on keyboard settings. You can also use the calculation commands on the Formulas tab.

When a chart is copied, renamed, or moved between sheets, its source references may still point to the original cells. Select Data shows which range it currently uses. If the chart is intended to show data from another worksheet, edit the references there rather than rebuilding the chart before checking. For PivotCharts, refresh the associated PivotTable when its source data has changed; a regular chart and a PivotChart do not update through exactly the same workflow.

Use a quick diagnostic sequence

When the cause is unclear, change one thing at a time and compare the chart after each check. This makes it easier to find the cause and avoids changing formatting that was already correct. A useful order is:

Check Chart Filters for excluded series or categories.
Open Select Data and verify the overall range, series values, and category labels.
Compare several plotted points with their source cells, checking for text, blanks, errors, or unexpected zeroes.
Review hidden rows and columns and the Hidden and Empty Cells setting.
Inspect axis bounds, axis type, and whether a secondary axis is in use.
Confirm the chart type matches the structure of the data, then check whether the source range includes newly added rows.

If a temporary copy of the chart behaves correctly after changing its type or data range, that is a useful clue, but it does not prove the original source values are correct. Keep the worksheet data as the reference and compare values directly. Avoid deleting and recreating a chart as the first step: doing so can remove useful formatting while leaving the underlying data problem unchanged.

Frequently Asked Questions

Why is my Excel chart missing some data?
Check the chart’s source range in Chart Design > Select Data, then inspect the chart filter and the Hidden and Empty Cells setting. Also confirm that the missing values are numeric where expected and that the rows are not excluded by a filter or hidden-data setting.

Why does my Excel chart show the wrong labels?
In Select Data, review Horizontal (Category) Axis Labels and confirm the range contains the intended labels, not a data column or header row. If rows and columns were interpreted backwards, try Chart Design > Switch Row/Column and check the result.

Why does Excel show zero instead of a blank in a chart?
A source cell containing zero is a real value, while a blank or formula result that looks blank may be handled differently. In Chart Design > Select Data > Hidden and Empty Cells, choose how empty cells should display, and check the source cell to see whether it contains zero, a formula, or no value.

Why does my chart not update when I add data?
The chart may use a fixed range that stops above the new rows, or formulas may not have recalculated. Check the range in Select Data and the workbook’s calculation setting. Using an Excel table as the source can help charts include rows added to that table.

Why does my line chart make the data look uneven?
A Line chart spaces categories evenly, even when dates or numeric values are separated by different intervals. If the horizontal values represent actual numbers or elapsed time, a Scatter chart may better represent their spacing. Check that the source x-values are real numbers or dates, not text.

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.