Excel Not Plotting Data Correctly? Fix the Chart

Charts & pivot tables · Updated November 18, 2026

If Excel is not plotting data correctly, select the chart and go to Chart Design > Select Data to check its source range and series; then confirm the cells contain the values and labels you intend to chart. The most common causes are an incorrect range, numbers or dates stored as text, a chart type that does not match the data, or axis and blank-cell settings that change how values appear.

Start by checking the chart’s data source

A chart can look wrong simply because Excel included the wrong cells. Select the chart, choose Chart Design > Select Data, and inspect the Chart data range field. The highlighted range should include the intended values and, where applicable, the row or column labels. If the range is difficult to edit as one continuous address, check each series in the Legend Entries (Series) list instead.

Select a series and choose Edit to inspect its series name and values. For a line or column chart, also check the category labels listed on the horizontal axis. A common mistake is including a totals row, an extra blank column, or a heading that Excel interprets as a data point. Another is selecting a label column but leaving out the corresponding numeric values.

For example, if a table has months in column A and sales in column B, the chart should use the months as category labels and the sales figures as the series values. If the chart shows January and February as separate series, rather than as horizontal-axis labels, Excel may have interpreted the data orientation incorrectly. In the Select Data Source dialog, use Switch Row/Column to change that interpretation.

Check how Excel interpreted rows and columns

Excel infers the chart layout from the selection. A simple table with headings across the top and labels down the first column is usually interpreted as one series per numeric column. A layout with series names down the first column may instead need one series per row. The guess can be wrong, especially with small tables, multiple header rows, or several adjacent blocks of data.

Use Switch Row/Column in Chart Design > Select Data to compare both interpretations. The change is not a data transformation: it tells the chart which direction represents separate series and which direction represents categories. Read the legend and axis labels after switching. If they now match the meaning of the table, keep that orientation; otherwise, edit the series and category-label ranges directly.

For a clearer source, arrange the data in a rectangular table with one header row, one record per row, and one type of measurement in each column. Avoid merged cells and decorative blank rows inside the range. Those features can make it harder for Excel to identify headings and can create unwanted gaps or categories.

Make sure numbers and dates are real values

Cells can look numeric while containing text. This often happens after copying data from a website or importing a text file. Text values may align differently from numbers, and a chart may omit them, treat them unexpectedly, or fail to use them as numeric positions. Check a few source cells by selecting them and looking at the formula bar and number format. A green error indicator may offer Convert to Number, but not every text-formatted value displays one.

To convert imported values, select the affected cells and use Data > Text to Columns, then choose Finish if the import preview already separates the values correctly. Alternatively, use the warning menu’s Convert to Number option when it is available. Check decimal and thousands separators before converting: a value such as 1,25 can be read differently depending on the file’s regional conventions. Converting a column without checking its meaning can produce the wrong numbers.

Dates need particular attention because charts use underlying date values, not just the way dates look on screen. A date that Excel recognizes can be formatted to display as a month name, while a date imported as text may not behave as a date axis. If an imported date column is not recognized, check the source format and regional date order before converting it. For example, 03/04/2026 is ambiguous unless you know whether the source uses month/day/year or day/month/year.

Choose a chart type that fits the data

Different chart types interpret the horizontal axis differently. A line chart is useful for showing a trend across ordered categories such as months. Its horizontal axis is generally a category axis, so category spacing does not necessarily represent elapsed time. A scatter chart, also called an XY chart, uses numeric x-values and positions points according to their actual numerical spacing.

If you are plotting measurements against a numeric variable, such as temperature against time in minutes or height against weight, try an XY scatter chart. Select the chart, choose Chart Design > Change Chart Type, and choose an option under Scatter. Then check the series’ X values and Y values in Select Data. A frequent error is putting both columns into Y values or using a text label column as the X values.

For monthly totals or named categories, a line or column chart is often more suitable. If a chart has two measures with very different scales, a combo chart can sometimes make both visible, but a secondary axis can also make comparisons misleading. Label both axes clearly and explain why they use different scales. Changing chart type is a useful diagnostic: if the points land where expected in a scatter chart, the original issue may have been the line chart’s category-based axis.

Inspect the axes, scale, and date spacing

An axis can hide or exaggerate differences even when the plotted values are correct. Select the axis, open Format Axis, and inspect its bounds, units, and number format. If the minimum or maximum bound is fixed, values outside that range may be cut off, and small changes can appear much larger than they would on an axis starting at zero. Set a bound back to Auto when you want Excel to choose a scale, or enter deliberate bounds when the chart needs a consistent comparison.

For a line chart with dates, Excel may show dates as categories or use a date axis. Select the horizontal axis and check Format Axis > Axis Options for the axis-type setting. A date axis can represent time intervals more faithfully, while a category axis gives each listed item its own position. If dates are missing, duplicated, or irregularly spaced, the difference can change the apparent trend.

A logarithmic scale is another setting to check if values seem compressed. It changes how distances on the axis correspond to values and cannot represent zero or negative values. Use it only when the data and purpose justify it, and label the axis so readers do not mistake it for a linear scale.

Review blanks, hidden rows, and filters

Blank cells can create gaps in a line, be displayed as zero, or be connected across, depending on the chart’s settings. Select the chart and open Chart Design > Select Data > Hidden and Empty Cells. Review the options for empty cells and choose the treatment that matches the meaning of the missing observations. A zero means a measured value of zero; a gap means no plotted value. They are not interchangeable.

Be cautious with formulas that return an empty string, because a cell that looks blank can still contain a formula. If the line behaves unexpectedly, inspect the source cells and test how the selected chart type displays those results. Do not replace missing data with zero merely to remove a gap unless zero is genuinely the correct value.

Hidden rows and columns can also affect what appears. In the Hidden and Empty Cells dialog, check Show data in hidden rows and columns if the chart should include those values. If the chart has a filter button, open it and confirm that the relevant series and categories are selected. A chart filter can hide data without changing the underlying worksheet table.

Make charts include new data

If a chart stops before the latest rows, its source range may be fixed. Open Chart Design > Select Data and extend the chart data range or the relevant series ranges to include the new records. This is common when data has been pasted below the original range rather than inserted within it.

For data that grows over time, consider converting the source range to an Excel table: select a cell in the data and choose Insert > Table, or press Ctrl+T on Windows. Confirm that the table has headers if it does. Charts based on table data can expand as rows are added to the table, which reduces the need to edit the chart range repeatedly. Check that new entries are actually part of the table and that the chart uses the table as its source.

When you add a new category or series, confirm that its heading and values are in the same table structure as the existing data. A chart will not necessarily detect a new column separated from the original range by a blank column or placed in a different worksheet area.

A practical troubleshooting order

Use this sequence to narrow the cause without rebuilding the chart. After each change, check whether the result now matches the worksheet and the meaning of the data.

  1. Select the chart and inspect Chart Design > Select Data for the range, series, and category labels.
  2. Use Switch Row/Column if Excel has treated categories as series or series as categories.
  3. Check source cells for text-formatted numbers, unrecognized dates, extra headings, and unintended blanks.
  4. Confirm that the chart type suits the data, especially whether the horizontal values are categories or numeric measurements.
  5. Inspect axis bounds, date-axis settings, chart filters, and the treatment of hidden or empty cells.
  6. If new rows are missing, extend the source range or use a structured Excel table as the chart source.

On Microsoft 365 for Windows, the chart-specific options appear on the Chart Design tab after selecting a chart. Excel for Mac has comparable chart design and data-selection controls, though ribbon placement can differ by version. In Excel for the web, some chart-editing controls may be arranged differently or be less complete than the desktop app.

Frequently Asked Questions

Why is Excel showing the wrong data series? Excel may have guessed the wrong row-and-column orientation or included the wrong range. Open Chart Design > Select Data, check the series and category labels, and try Switch Row/Column. Remove any totals or unrelated columns from the chart source if they were included by mistake.

Why does my chart show zero instead of a blank? Check whether the source cell contains zero, a formula returning an empty string, or a genuinely empty cell. Then inspect Chart Design > Select Data > Hidden and Empty Cells. The appropriate display depends on the chart type and setting; use zero only when the value really is zero.

Why is my Excel chart not updating when I add data? The chart may use a fixed range that ends before the new rows. Inspect the range in Select Data and extend it, or use an Excel table as the chart source. Also confirm that the new rows were added inside the table rather than pasted below it as unrelated worksheet cells.

Should I use a line chart or a scatter chart? Use a line chart for an ordered sequence of categories, such as months, when equal category spacing is acceptable. Use an XY scatter chart when both axes represent numeric values and the horizontal spacing between observations matters.

Why are dates spaced unevenly or displayed as numbers? Excel may not recognize the source cells as dates, or the horizontal axis may use a different axis type than you expect. Check the source values and regional date order, then inspect Format Axis for the horizontal axis. A recognized date can also display as a serial number if its cell or axis number format is not set to a date format.

Related

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.