Excel Not Making Graphs Correctly? Fix Common Causes

If Excel is not making graphs correctly, first check that the chart uses the intended data range, treats the first row or column as labels, and has the right chart type. Select the chart and go to Chart Design > Select Data to inspect its series and category labels; correcting those settings fixes many charts that look blank, reversed, incomplete, or misleading.

Start With the Data Range

A chart can only represent the cells included in its source range. If you selected too few rows, the graph may omit recent records; if you included totals, notes, or unrelated columns, it may plot them as if they were data. Click the chart and look for the colored outlines around its source cells. If the outlines do not match the intended table, adjust the range in the Select Data Source dialog.

Select the chart, then choose Chart Design > Select Data.
In the Chart data range box, confirm that the range includes the intended labels and values, but excludes unrelated cells.
Use the controls in the dialog to edit or remove an unwanted series, or choose a different range.
Select OK and check that the chart now reflects the full data set.

For example, a table with months in column A and revenue in column B usually needs both columns selected, including the month names as category labels. Selecting only the revenue values can produce generic categories such as 1, 2, and 3. Including a grand-total row can add a large extra bar or point that distorts the scale. If you need a nonadjacent range, select the first range and hold Ctrl while selecting the other range in Excel for Windows; on Mac, use Command while selecting.

Check How Excel Interprets Rows and Columns

Excel has to decide whether each row or each column represents a data series. If it guesses the opposite of what you intended, a chart may show one series for every row instead of one for each product, or may put product names along the vertical axis. Select the chart and choose Chart Design > Switch Row/Column to change the interpretation. This is most useful when the data is arranged in a rectangular table with labels in its first row or column.

Use the layout that makes the question easy to read. For a monthly sales comparison, months are often the categories and product names are the series. For comparing each product’s change over time, the same arrangement may work, but the chart’s emphasis changes. If switching rows and columns produces confusing labels or too many series, return to Select Data and inspect the ranges rather than repeatedly changing chart styles.

Choose a Chart Type That Fits the Values

A chart can be technically correct but still communicate the wrong thing. Column and bar charts are useful for comparing categories. Line charts are commonly used to show changes across an ordered sequence, such as dates. Scatter charts are designed to plot paired numeric values on horizontal and vertical axes, making them appropriate for examining relationships between two measurements. A pie chart is intended for showing parts of a whole and is difficult to interpret when there are many categories or values that do not form a meaningful total.

To change a chart, select it and choose Chart Design > Change Chart Type. Excel’s Recommended Charts option can suggest a suitable format based on the selected data, but a recommendation still needs a quick check: confirm that categories and series make sense, and that the scale does not hide important differences. A line chart may connect points in category order even when the horizontal values should be treated as measured numbers; in that case, a scatter chart may be a better fit.

Fix Axis Labels, Dates, and Scales

Unexpected axis labels often point to a data-interpretation issue. If a chart shows 1, 2, 3 instead of names, the category-label range may be missing. In Chart Design > Select Data, check Horizontal (Category) Axis Labels and choose Edit to specify the cells containing the intended labels. For a chart where Excel has assigned the categories and series backwards, use Switch Row/Column or correct the series setup in the same dialog.

Date axes can also look odd. A date may be stored as text rather than as a genuine Excel date, or the axis may display dates at an interval that makes labels crowded. Check the source cells first: dates should behave as dates when formatted or sorted, rather than as unrecognized text. Right-click the horizontal axis and choose Format Axis to review available axis options, including date-axis settings where applicable. The options differ according to chart type and the data Excel recognizes.

For a vertical axis that starts at an unexpected value, right-click that axis and choose Format Axis. Excel may use automatic minimum and maximum bounds; setting bounds manually can make a comparison easier to see, but it can also exaggerate differences if the scale is narrowed. For example, a bar chart of values close to 100 can look dramatically different when its vertical axis starts near 95 rather than zero. Choose a scale that fits the purpose and does not mislead the reader.

Look for Text, Blanks, and Errors in the Source

Numbers that look numeric may be stored as text. This can happen after importing data, pasting values from another system, or using inconsistent decimal and thousands separators. Text values may be ignored or handled differently from numbers in a chart. Check a few source cells by selecting them and reviewing their alignment and number format, but do not rely on appearance alone: a cell can be formatted as a number while still containing text. Correct the underlying data using an appropriate conversion method before expecting a reliable graph.

Blank cells and formula results that display as empty strings can create gaps or unexpected connections. Select the chart and choose Chart Design > Select Data, then choose Hidden and Empty Cells to review how empty cells are displayed. Available choices include showing empty cells as gaps, zero, or connecting data points with a line, depending on the chart and dialog options. Pick the treatment that accurately represents missing information. A missing measurement is not automatically the same as zero.

Also check for error values, duplicate labels, extra spaces in category names, and totals mixed into the detail rows. A single outlier can stretch an axis until the other values appear nearly flat. Sorting or filtering the source data can help reveal whether the chart reflects an unexpected record, but confirm that any excluded data is intentionally excluded.

Understand Series and Secondary Axes

Each plotted series should represent one meaningful set of values. In Chart Design > Select Data, review the series names and values. A series name should generally point to a descriptive header cell, while its values should point to the matching numeric cells. If one series has fewer values than the category range, the chart may show gaps or incomplete points. Make sure all series refer to aligned rows or columns.

A secondary axis can help when two series use very different units or scales, such as revenue and percentage rate. It can also make a graph harder to interpret if viewers assume both series share the same scale. To use one, select the relevant series, open Format Data Series, and choose the secondary-axis option when available. Label both axes clearly and explain the units. Do not add a secondary axis simply to make a line or column appear more prominent.

For combination charts, select Chart Design > Change Chart Type and choose a combination option if it suits the data. Excel can assign different chart types to different series, and some combinations permit a secondary axis. Check the legend, axis titles, and units after changing the configuration; otherwise, a technically valid chart can still leave readers unsure what each line or bar means.

Check Whether the Chart Updates

If a graph does not include newly added rows, inspect its source range. Data entered below a fixed chart range may not be included automatically. Converting a well-structured source range into an Excel table can make it easier to maintain: select a cell in the data and choose Insert > Table, then confirm whether the table has headers. Charts based on a table can expand as rows are added to that table, though you should verify the chart’s source if it does not show the new records.

PivotCharts work differently from ordinary charts. They are linked to a PivotTable and its source, so changes to the underlying data may require refreshing the PivotTable before the chart reflects them. Use Data > Refresh All, or right-click the PivotTable and choose Refresh. Also check PivotTable filters, slicers, and field selections; a chart can be accurately plotting only the subset currently visible.

For a chart that appears frozen, first confirm whether its source cells changed and whether calculation or refresh is needed. Then check filters and the selected range. Avoid rebuilding the chart as a first response: changing the source or refresh settings is often enough, and rebuilding can discard useful titles, formatting, or axis choices.

Distinguish a Data Problem From a Display Problem

Sometimes the chart data is correct but the display is not. A small chart may crowd labels; a legend can cover the plot; and a title may be missing or misleading. Select the chart and use the Chart Elements, Chart Styles, and Chart Filters controls that appear beside it, or use the options on the Chart Design tab. Add a chart title and axis titles when they help explain the measurement and units. Resizing the chart or moving the legend can improve readability without changing the data.

If the chart looks different after copying, printing, or opening the workbook on another device, check the display context and page layout. Fonts and available space can affect how labels fit. Excel for the web and Excel for Mac support common chart editing, but some controls and dialog layouts differ from Excel for Microsoft 365 on Windows. If a named option is not visible, check the corresponding chart or formatting pane rather than assuming the workbook’s values have changed.

Frequently Asked Questions

Why is Excel making a graph with the wrong labels?
Excel may have selected the wrong category-label cells or interpreted rows and columns differently than you intended. Select the chart, open Chart Design > Select Data, and edit Horizontal (Category) Axis Labels. Also check whether Switch Row/Column gives the intended arrangement.

Why does my Excel chart show only one data point?
The chart may reference only one value, or its series range may not cover the full data set. Check the Chart data range and each series under Chart Design > Select Data. Confirm that the source cells contain numeric values and that filters have not hidden the other records.

Why is my chart blank even though the cells have numbers?
Check that the chart’s source range includes those cells, that the values are numeric rather than text, and that filters or hidden rows are not excluding them. Also review the chart type and the series ranges. If the values come from formulas, check that the formulas currently return usable results.

How do I make an Excel graph include new rows?
Check whether the chart’s source range ends before the new data. Extend the range in Chart Design > Select Data, or use an Excel table as the chart source so added table rows can be included more easily. For a PivotChart, refresh the associated PivotTable and check its filters.

Why does Excel show dates or numbers strangely on the axis?
The source values may be stored as text, or Excel may have chosen an unsuitable axis scale or date interval. Verify the underlying cell values, then right-click the axis and choose Format Axis to review its options. Use a chart type appropriate to the data, especially when numeric horizontal values need proportional spacing.

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.