Excel Graph Not Showing All Data? How to Fix It

Charts & pivot tables · Updated November 18, 2026

If an Excel graph is missing selected data, check its source range first: select the chart, choose Chart Design > Select Data, and confirm the chart data range includes every intended row and column. Then check whether filters, hidden rows, blank cells, chart type, or axis limits are preventing included values from appearing.

Why an Excel graph can omit data

A chart displays data from its source range, but selecting cells when you first create a chart does not guarantee that every value will appear as a visible point, bar, or category. Excel also interprets the arrangement of the selected cells, respects some worksheet filters, and applies chart and axis settings. A value can therefore be present in the worksheet and technically included in the chart source while still being difficult to see or not displayed at all.

It helps to separate three questions: Is the cell inside the chart’s source range? Is Excel treating its row or column as eligible to plot? If it is eligible, is the chart’s layout and scale making it visible? Checking those in order is usually faster than rebuilding the graph.

For example, suppose a table has monthly sales in rows 2 through 13, but the chart source ends at row 10. The last three months are outside the source, so changing the axis will not bring them back. If all 12 months are in the source but rows 11 through 13 are filtered out, the chart may omit those rows until the filter is cleared or the chart is set to include hidden and filtered data.

Confirm the chart’s source range

In Excel for Microsoft 365 on Windows, click the chart and open Chart Design > Select Data. The Chart data range box shows the worksheet cells currently feeding the chart. Check that the range covers the full set of category labels and all intended series, including the last data row or column. In the same window, review the Legend Entries (Series) list and the Horizontal (Category) Axis Labels list. A series can be missing even when the overall range looks plausible if Excel interpreted the layout differently than expected.

If the chart was created from non-adjacent ranges, inspect each listed series rather than relying only on the range box. Select a series and choose Edit to check its series name, series values, and category labels. A common example is a chart that includes the labels in column A and values in column B, but leaves out a second year in column C because only columns A and B were selected.

On a Mac, select the chart and use the Chart Design tab’s Select Data command; the dialog and labels can vary slightly by Excel release. If the command is unavailable or the chart is a PivotChart, use the chart’s own field or filter controls as well. Excel for the web offers chart editing, but some detailed chart options are more limited than in the desktop app.

For a quick visual check, click the chart and look at the colored outlines Excel places around the source cells on the worksheet. If those outlines stop before the missing records, adjust the source range in Select Data. Avoid dragging the outline by guesswork when the chart uses several series: the dialog makes it easier to verify which values belong to each series.

Check filters and hidden rows or columns

Worksheet filters are a frequent cause of missing chart points. If the source data is an Excel table or has AutoFilter enabled, filtered-out rows are generally excluded from a chart. Clear the relevant filter with the filter arrow in the column header, or choose Data > Clear to clear worksheet filters. If the missing categories return, the chart itself was not necessarily broken; it was responding to the visible data.

Hidden rows and columns can also be omitted by default. To change that behavior, select the chart, choose Chart Design > Select Data, and select Hidden and Empty Cells. In the dialog, enable Show data in hidden rows and columns, then confirm. The equivalent option is available in desktop Excel for Mac, though its placement or wording may differ slightly by version. This setting is useful when rows are intentionally hidden for presentation but should still contribute to the graph.

Also check whether the chart has its own filters. When selected, some chart types display a Chart Filters button, usually shown as a funnel beside the chart. Open it and make sure the missing series or categories are checked, then choose Apply. A chart filter is separate from a worksheet filter: clearing one does not necessarily clear the other.

Understand blanks, text, and error values

A blank cell is not the same as a zero. Depending on the chart type and the chart’s empty-cell setting, Excel may leave a gap, connect neighboring points with a line, or display a zero-like result. Select the chart, open Chart Design > Select Data > Hidden and Empty Cells, and review how empty cells are shown. The available choices commonly include gaps, zero values, or connecting data points with a line. Choose the interpretation that matches what an empty cell means in your dataset.

Check whether values that look numeric are actually stored as text. Numbers imported with leading apostrophes, unusual separators, or inconsistent decimal conventions may not behave like numbers in a value series. Select a suspect cell and inspect the formula bar and number alignment; a green error indicator may also offer a conversion option. Converting text to numbers can restore plotting, but confirm that the conversion preserves the intended decimal and thousands separators.

Formula results can cause similar confusion. A formula that returns an empty string may look blank without being an empty cell in the ordinary sense, and an error such as #N/A may not plot as a normal value. Review the cells behind the missing points and decide whether the formula result represents missing information, a genuine zero, or an error that needs correcting. Do not replace missing values with zero unless zero is an accurate meaning for the data.

Check how Excel arranged the data

Excel decides whether rows or columns represent separate series when a chart is created. If the result is plotting the wrong groups, select the chart and choose Chart Design > Switch Row/Column. This changes the interpretation; it does not add cells that are outside the source range. It is particularly useful when a dataset has categories across columns but Excel has treated each row as a series, or vice versa.

Headers matter because Excel may use the first row or column as series names and category labels. A blank or duplicated header can make the legend confusing, while selecting an extra title row can make Excel interpret text as data. Arrange the source as a clear rectangle with one header row, one label column where appropriate, and numeric values in the body. For example, put months in column A, then separate product sales in columns B and C, with a descriptive heading at the top of each value column.

For an XY scatter chart, each series uses paired X and Y values. If one range contains 12 X values and the corresponding Y range contains only 10, some intended points cannot be plotted as expected. In Select Data, edit the series and check both ranges. This differs from a standard line chart, which commonly treats the horizontal axis as categories rather than using each label as a numeric X coordinate.

Look for axis limits and chart-type issues

A point may be included but fall outside the visible plot area because the axis bounds are fixed. Right-click the relevant axis, choose Format Axis, and inspect Bounds such as Minimum and Maximum. If a maximum was manually set below the largest value, change it to Auto or enter a suitable value. For a date axis, also check the displayed date range and units; Excel may space dates as a continuous time scale rather than as equally spaced text categories.

Scale can make small values look almost invisible when one series has much larger values. A chart with values near 5 and another series near 5,000, for example, can flatten the smaller series against the baseline. Consider whether separate charts or a secondary axis are appropriate, while clearly labeling any secondary axis so readers do not mistake the scales. A secondary axis changes how values are displayed, not the underlying data.

Some chart types cannot show every kind of data meaningfully. A pie chart represents parts of one whole and is not designed to compare multiple independent series; a line chart may connect categories in a way that implies an order. If data appears absent after adding a series, try a column chart or another suitable type using Chart Design > Change Chart Type. For a combination chart, verify which chart type and axis are assigned to each series.

Make charts include data added later

A chart made from a fixed cell range may not expand when new records are entered beneath that range. If the original source is A1:B10, adding a record in row 11 does not always make that row part of the chart. Open Select Data and extend the source range, or convert a tidy data range into an Excel table using Insert > Table. Charts based on a table are generally better at including rows added to that table.

When adding a row to a table, enter it directly in the row immediately below the table or expand the table to include it. A row separated by a blank line may not be recognized as part of the table. Similarly, a new column outside the table boundaries will not automatically become a table field. Verify the table boundary before assuming the chart failed to update.

For reports that regularly receive new data, keep the chart source structure consistent: one record per row, one field per column, and no completely blank separator rows within the data. This makes tables, filters, and charts easier to maintain. If the workbook uses named ranges or formulas as chart sources, inspect those definitions too; they may still point to an older endpoint even when the worksheet visibly contains more records.

A practical troubleshooting sequence

Use this order to find the cause without changing several settings at once:

  1. Select the chart and use Chart Design > Select Data to check the source range, series, and category labels.
  2. Clear worksheet filters temporarily and check the chart’s funnel filter, if it appears.
  3. Open Hidden and Empty Cells and review whether hidden rows or columns should be plotted.
  4. Inspect the missing source cells for blanks, text-formatted numbers, errors, or formulas returning empty strings.
  5. Check whether rows or columns should be treated as series, and try Switch Row/Column if the layout is reversed.
  6. Review axis bounds, date-axis settings, and whether the selected chart type suits the data.
  7. If the missing values are newly added records, extend the range or confirm that the rows are inside the source table.

After each change, compare the chart with the source data so you know what fixed the problem. If the chart is part of a dashboard, save a copy before making major structural changes, especially if other formulas or charts depend on the same table. A PivotChart may need its underlying PivotTable refreshed and its field filters checked; its displayed data is controlled by the pivot layout as well as the chart.

Frequently Asked Questions

Why does my Excel chart stop before the last row?
Most often, the chart’s source range ends before the last row. Select the chart, choose Chart Design > Select Data, and check the range and individual series. If the data was added after chart creation, extend the range or use a table-based source that can expand with added records.

Why does my chart change when I filter the worksheet?
Charts generally respond to filtered source data and show the visible records. Clear the worksheet filter to restore the rows, or use the Hidden and Empty Cells dialog to include hidden rows and columns when appropriate. Also check the chart’s separate Chart Filters control.

Why are some selected cells missing from an Excel graph?
They may be outside the actual chart source, hidden by a worksheet or chart filter, blank, stored as text, or interpreted as labels rather than values. A point can also be outside fixed axis bounds. Check the source range first, then investigate those conditions.

How do I show hidden data in an Excel chart?
Select the chart and open Chart Design > Select Data > Hidden and Empty Cells. Select Show data in hidden rows and columns and confirm. This setting controls hidden worksheet cells; it does not override every chart filter or repair an incomplete source range.

Why does Excel not include new rows in my chart?
A chart based on a fixed range may not expand when data is added beyond its final row. Extend the chart source in Select Data, or place the records inside an Excel table used by the chart. Make sure there is no blank row separating the new record from the table.

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.