If data is not showing in an Excel chart, first select the chart and check its source range at Chart Design > Select Data; the missing cells may be outside that range, filtered out, or hidden. Then check whether the chart type, blank-cell settings, and axis limits allow the values to appear.
Start with the quickest checks
Before changing the worksheet, click the chart and look for a chart filter button beside it, if one is available. Open it and confirm the missing categories or series are selected. A chart can retain a filter even after its source data changes, so the worksheet may contain the right values while the chart deliberately omits them.
Next, compare the chart with its source. Click a visible plotted point or bar to identify its series, then inspect the source table and the chart legend. If an entire series is missing, the issue is often the selected range, a hidden row or column, or a series that was removed. If only some points are absent, check blank cells, filters, and the axis scale.
- Confirm the chart is linked to the worksheet and data you expect.
- Check whether the missing values are actually present and numeric in the source cells.
- Look for hidden rows, hidden columns, or filters that exclude the source records.
- Inspect the axis bounds and chart type before rebuilding the chart.
These checks help distinguish a display problem from a data problem. For example, if a cell contains a number stored as text, it may not behave as a numeric value in a value-based chart. If the cell is genuinely empty, Excel cannot plot a value there.
Check the chart’s data range and series
In Excel for Microsoft 365 on Windows, select the chart and choose Chart Design > Select Data. The Select Data Source dialog shows the range used by the chart and the series it contains. Check that the range includes the missing rows or columns, and that the Horizontal (Category) Axis Labels point to the intended label cells.
For example, a chart may use cells A1:B6 even though the latest month and its sales value are in row 7. Expand the chart’s source range to include row 7, or adjust the series range and category-label range in Select Data Source. If the chart includes labels but not values, inspect the series entry: choose it under Legend Entries (Series), select Edit, and verify the Series values field covers the correct numeric cells. Also check that the series name points to the intended heading cell.
When editing a range, include matching numbers of category labels and values. A range that accidentally includes a title, blank row, or unrelated column can make Excel interpret the data in an unexpected way. If the rows and columns are arranged opposite to the chart’s current interpretation, use Chart Design > Switch Row/Column to see whether that fixes the series layout.
When you regularly append records, format the source as an Excel table using Home > Format as Table, then build or reconnect the chart to the table. Charts based on tables can include added table rows as the table grows. Still verify the source after a structural change: a chart copied from another worksheet or workbook, or a chart with a manually edited series range, may not use the table you expect.
Unhide rows and review blank-cell settings
By default, a chart may not display data from hidden rows or columns. This often explains why a chart appears incomplete even though the values are still on the sheet. Select the chart, open Chart Design > Select Data, choose Hidden and Empty Cells, and select Show data in hidden rows and columns if those values should be included. This setting does not unhide worksheet rows; it tells the chart whether to plot data that remains hidden.
Also inspect the source for blank cells. In the same Hidden and Empty Cells dialog, Excel lets you choose how empty cells are displayed. Depending on the chart and the selected option, empty cells can appear as gaps, as zero values, or, for line charts, with data points connected across the gap. Choose the display that represents the meaning of the data. Treating a missing measurement as zero can be misleading: no recorded value is not necessarily the same as a measured zero.
A formula that displays an empty string is another source of confusion. A cell containing a formula that returns an empty string is not truly an unused cell, even though it looks blank on the worksheet. Its chart behavior can differ from a genuinely empty cell and may depend on the chart type and settings. If a point unexpectedly appears at zero or creates a gap, inspect the formula and test the chart with a genuinely blank source cell before deciding how missing observations should be represented.
Look for filters and axis limits
A chart can omit valid data because a category or series is filtered out. If the chart has a Chart Filters button, select it and review both the Categories and Series lists, then apply the changes. Worksheet filters can also affect what is visible in the source, especially when chart settings exclude hidden rows. Check the filter arrows in the source table and clear any filters that are not intentional.
Values may also be present but fall outside the visible axis range. Right-click or Control-click the value axis and choose Format Axis. In the Format Axis pane, review Bounds, including Minimum and Maximum, and set them back to Auto if fixed limits exclude the data. For example, a vertical axis capped at 100 cannot show a value of 125 within the plot area. A logarithmic scale, unusual major units, or a secondary axis can also make a series look absent or compressed.
For category labels, check whether the axis is showing every label or only some of them. Excel may skip labels to avoid crowding, particularly when there are many dates or categories; the data points may still be plotted. If the values themselves are missing, however, changing label intervals will not restore them. Confirm the selected axis is the one associated with the missing series, especially in a combination chart with a secondary axis.
Confirm the source values are usable
Some apparent chart failures start in the cells. A number imported from a text file may look like 250 but be stored as text. In a chart that expects numeric values, text entries may be treated as labels or not plotted as expected. Check a few cells by selecting them and looking at the formula bar, number format, and alignment; formatting alone is not conclusive, but it can reveal a mismatch. Correct the source data rather than forcing a chart to interpret inconsistent entries.
Dates can cause similar confusion. Excel stores valid dates as serial numbers, but text that resembles a date may not be recognized as a date. If the horizontal axis treats dates as separate text categories, sort order and spacing may differ from a true date axis. Convert the source entries to real Excel dates, then check the axis options. In charts where date spacing matters, a value axis or a date axis may be more suitable than text categories, depending on the chart type.
Check for errors such as #N/A or #VALUE! in the plotted range as well. An error is not a normal numeric observation, and it may leave a gap or prevent an expected point from appearing. If the source uses formulas, inspect the formulas and their results rather than only their displayed formatting. Avoid hiding errors by changing the chart first; determine whether the error means the observation is unavailable, invalid, or simply calculated incorrectly.
Make sure the chart type fits the data
The chosen chart type affects how Excel interprets values. A line chart is useful for ordered categories or time sequences, while a scatter chart plots numeric x-values against numeric y-values. If a scatter chart uses text or dates in an unexpected format for its x-values, points may not land where expected. A column chart is often easier to read when comparing values across named categories. Switching chart type can reveal data that was present but poorly represented by the original layout.
Review the arrangement of the source too. In a table with months in the first column and several product columns beside them, Excel may treat each product as a separate series. If it instead creates one series per month, Chart Design > Switch Row/Column can correct the interpretation. This changes how Excel groups the existing cells; it does not add missing data or repair incorrect cell values.
Combination charts deserve a separate check because different series can use different chart types and axes. Select the chart and use Chart Design > Change Chart Type to review the series assignments. If one series is plotted on a secondary axis, confirm that axis is visible and scaled appropriately. A small series sharing an axis with much larger values may look like a flat line, even though it is plotted.
Refresh PivotCharts and imported data
If the chart is a PivotChart, it reflects the associated PivotTable rather than simply plotting every cell in a range. New source records may not appear until the PivotTable is refreshed. Select the PivotTable and choose Data > Refresh, or use Data > Refresh All when several connections or tables need updating. Then check the PivotTable’s filters, field layout, and date grouping; these can limit what the PivotChart displays.
Refreshing does not automatically fix an incorrect PivotTable source. If added records lie outside the original source range, update the PivotTable source or use an Excel table as the source so its range can expand with new rows. For data loaded through a query or external connection, confirm the refresh completes and that the expected records are present in the resulting table. A chart cannot show records that have not been loaded into its underlying data.
A reliable troubleshooting sequence
Use a consistent order so you do not rebuild a chart before finding the cause. Start with the chart filter, then verify the source range and series in Select Data Source. Next, inspect the worksheet for hidden rows, filters, blanks, text values, and errors. Finish by checking axis bounds, chart type, and any PivotTable refresh requirement.
If the issue remains, make a small diagnostic chart from a few known-good cells on a clean part of the worksheet. Include one category column and one numeric value column, with clear headings. If the small chart works, the original chart’s source, filters, or settings are likely responsible. If it does not, check the values and their data types. This test narrows the problem without discarding the original chart or its formatting.
On Excel for Mac, the same chart concepts and Select Data controls are available, though ribbon placement and dialog appearance can differ. On Excel for the web, chart editing options may be more limited than in the Windows desktop app; if a setting is unavailable, open the workbook in desktop Excel to inspect it. Menu wording can vary slightly by update, but selecting the chart and looking under Chart Design is the usual starting point.
Frequently Asked Questions
Why is only part of my Excel chart showing?
Check whether the chart range ends too early, whether a chart or worksheet filter excludes records, and whether some source cells are blank, hidden, or errors. Then inspect the relevant axis bounds to see if values fall outside the displayed scale.
Why does my Excel chart show zero instead of a blank?
The source may contain a zero, a formula returning an empty string, or an empty-cell setting that plots blanks as zero. Inspect the source cell and the Hidden and Empty Cells options. Choose a gap or connected line where appropriate rather than treating every missing observation as zero.
How do I add new rows to an existing Excel chart?
Select the chart and choose Chart Design > Select Data to expand the source range, including the new values and matching labels. If records are added often, consider using an Excel table as the chart source, then confirm the chart includes the new table rows.
Why are my chart values treated as categories?
The chart type or source layout may be interpreting the cells differently than intended, or values may be stored as text. Check the series ranges and headings in Select Data Source, verify the cells contain real numbers, and try Switch Row/Column if the series grouping is reversed.
Why does my PivotChart not update when I add data?
Refresh the associated PivotTable using Data > Refresh or Data > Refresh All. If the new records are outside the PivotTable’s source range, update that source or base it on a table that expands as rows are added.
Related
- Count Numbers vs Count in Excel PivotTables
- Copy Paste in Excel: Keep Column Widths When Pasting
- Copy an Entire Excel Spreadsheet to a New File
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Histogram Format Options: Bins, Labels, and StyleIn Excel for Microsoft 365 on Windows, select a histogram and use Format Axis to change its bins,…
- Spider Web Chart in Excel: How to Create and Read ItA spider web chart—usually called a radar chart in Microsoft Excel—plots several categories around a circle so you…
- Excel Pivot Tables: How They Work and When to Use ThemAn Excel PivotTable is a tool for summarizing and exploring a larger list of data without changing the…
- Excel Average for Every 5-Unit X-Axis RangeTo find the average Y value in each 5-unit X-axis range in Excel, put the X values in…
- Bar Chart in Excel: How to Create and Format OneTo make a bar chart in Excel for Microsoft 365 on Windows, arrange category names in one column…
- Excel Dashboard vs Power BI: Which Should You Choose?Excel is usually the better choice for a small, flexible dashboard built around spreadsheets; Power BI is usually…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.