If an Excel chart seems to exaggerate a change or leave out data, check its axis, labels, plotted range, and source note before drawing conclusions. Excel can use automatic or custom axis bounds, and a chart can hide points or use labels that do not match the values. A confusing chart is not, by itself, evidence that anyone intended to mislead.
1. Check the axis scale before interpreting the trend
Excel sets the vertical value-axis scale automatically by default, but the bounds and intervals can be changed. Select or right-click the value axis and choose Format Axis. Review the minimum and maximum bounds, major-unit interval, number format, and whether the scale is linear or logarithmic. Microsoft documents these controls for Excel for Microsoft 365 and recent releases; ribbon wording and pane details can vary by platform and version. Microsoft explains how to change the vertical value-axis scale.
As an Amazon Associate I earn from qualifying purchases.
For bar and filled-area charts, check for zero
Bars encode magnitude by their length from a baseline. If the value axis starts above zero, a modest difference can look much larger. The UK Office for National Statistics (ONS) says a bar-chart axis should not start above zero and also recommends zero baselines for filled areas. If a zero-based bar chart makes small differences hard to see, consider a dot plot rather than truncating the bars. See the ONS guidance on axes and gridlines and its guidance on simple bar-chart comparisons.
Free tools Windows power users keep installed
One-click scans. No signup required.
For line charts, judge the scale in context
A nonzero vertical range is not automatically wrong for a line chart: it can make small movements in a continuous series easier to examine. But the bounds and actual values should be clear, so readers can judge the size of the change rather than relying on the slope alone. A logarithmic axis can help show values spanning a very large range, but it changes how visual distances relate to numerical differences; identify it plainly.
#1 Best Overall
Compare bounds and units across charts
When charts are meant to be compared, check that they use the same axis bounds and units. Otherwise, equal-looking bar heights or line slopes may represent different values or changes. If a chart uses a secondary axis for a different measure, label each axis and explain the comparison. Two lines crossing on different scales does not mean the values are equal at the crossing, or that one caused the other. ONS advises consistent scales for comparable charts and flags dual axes as a design consideration in its axis guidance.
2. Check labels, units, and dates
A chart should make clear what is being compared and how to read the numbers. Check that its title describes the comparison; axis titles name the measure; value ticks identify units such as dollars, people, or percent; category labels match the groups; and dates use the correct period and order. The US Census Bureau’s Statistical Quality Standard E2 calls for labeled axes and units. ONS also recommends clear, plain-language chart text in its chart-text guidance.
Inspect category labels
Category-axis labels usually come from worksheet cells. To inspect them, select the chart and open Chart Design > Select Data; review Horizontal (Category) Axis Labels. You can change the source cells or use chart-specific labels, but confirm that any custom text still describes the data accurately. Microsoft documents the options in its instructions for changing chart axis labels.
Check value-axis number formatting
Right-click the value axis, choose Format Axis, then inspect Number. A percentage format does not turn ordinary whole-number amounts into valid percentages: the worksheet should contain percentage values or decimals such as 0.1 for 10%. Microsoft cautions that values must be set up appropriately before applying percentage formatting and describes calculating a percentage by dividing an amount by the total. A percent sign on raw values can therefore make a chart look polished while communicating the wrong quantity; see Microsoft’s axis-label and number-format guidance.
Rank #3
3. Verify the data Excel plotted
A chart’s appearance does not show whether it includes the intended rows, columns, or series. Right-click the chart and choose Select Data. Compare each legend entry and its values, along with the category-label range, against the intended source table. Microsoft says chart data can come from continuous or noncontinuous ranges, and chart filters can show or hide points. Its documentation also warns that editing a series may break its link to worksheet data. See Microsoft’s guide to selecting chart data and its guide to changing data series.
- If a row or point is missing, check chart filters and whether rows are hidden.
- If the chart stops early or includes extra data, inspect the selected range and its endpoints.
- If a series looks unexpected, compare its cell references and formulas with the source table.
- If categories and series appear reversed, review how the worksheet is arranged and use Switch Row/Column or the Select Data controls where appropriate.
- If a series no longer reflects worksheet edits, verify that its link to the expected cells is intact.
4. Check the source note and context
A chart should identify where its data came from, with the source statement placed directly after the chart. Add a note when exclusions, definitions, or transformations materially affect how to interpret the values. ONS calls for a source after each chart, while the Census Bureau’s E2 standard covers source statements and clear graphics. A source note does not by itself verify the plotted range, but it gives readers a way to understand what the numbers represent and assess the chart’s context.
Quick Recap
Rank #4
A quick Excel chart audit
- Read the scale: Select or right-click the value axis and choose Format Axis. Inspect its bounds, intervals, number format, and scale type.
- Read the labels: Confirm the title, units, category names, and date order. For categories, use Chart Design > Select Data > Horizontal (Category) Axis Labels.
- Check the plotted range: Right-click the chart and choose Select Data. Compare series, values, and label ranges with the intended worksheet data; check filters and hidden rows.
- Check comparability and context: Compare scales and units across charts, identify secondary axes, and look for a source statement and any important definition or exclusion.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
