Quick answer
A chart can make a small change appear dramatic when its value axis starts close to the data. Inspect the minimum, maximum and units before assuming the source numbers are wrong.
Understand the problem before changing anything
For example, values of 98 and 100 look very different on an axis that begins at 97 than on one beginning at zero. Neither view explains itself without labels. Choose the scale according to what the chart is meant to communicate.
Step-by-step checks
Confirm the chart data
Select the series and verify the source cells. Check hidden rows, filters, units and whether the intended numbers are being plotted.
Open the value-axis options
In desktop Excel, select the vertical value axis and open Format Axis. Look at Bounds and the major unit, including any manually entered values.
Compare sensible alternatives
Try an automatic scale and a suitable zero baseline for a bar or column comparison. For a line chart showing small movement, a limited range may be useful if clearly labelled.
Check special scales
Confirm whether a logarithmic scale, secondary axis or reversed values are intentional. These settings change how readers interpret distances.
Review the exported result
Check axis labels and units in the PDF or screenshot you plan to share. Add a short note if a deliberately shortened axis could otherwise be misunderstood.
What to avoid
Do not choose axis bounds only to make a trend look stronger. Avoid comparing heights across charts with different scales unless those differences are explicit.
How to verify the result
A reader should be able to identify the scale, units and actual size of the difference without opening the workbook. The chart’s story should agree with its source values.
Check the workbook’s structure as well as the visible result
Work on a separate copy when the workbook supports invoices, stock, payroll or a shared report. A cell’s appearance is only one layer: its stored value, formula, number format and validation rule can differ. Record the affected worksheet and one example cell so you can compare the same case after each change.
Use a small, known example to test the intended behaviour. Check one ordinary row, one blank and one unusual value rather than judging a whole report from its grand total. If the workbook imports data, correct the import or source definition where possible; repeatedly correcting the final display can leave the same problem waiting for the next refresh.
Before sharing the result, check formulas that depend on the changed area and any charts or PivotTables fed by it. Save, close and reopen a working copy, then verify the same example. Mention any deliberate conversion of text, dates or identifiers so another user does not reverse it accidentally. If a colleague owns the workbook, agree changes to validation, protection and calculation settings rather than silently changing the model.
Before you finish
- Affected sheet and sample cell
- Original value compared with expected value
- Source, formula and display checked separately
- Dependent reports tested after saving
Common question
Must every chart start at zero?
Not every chart, but bar and column lengths usually need a meaningful zero baseline. Explain a restricted scale when showing small changes in a line chart.
Need help with the next step?
Tell RJ Computers the device model, exact symptom, checks already tried and whether important files are backed up. Confirm availability, assessment charges and the scope of work before arranging a visit.
Reference and version notes
Check the official instructions for your exact product version; menu names and available features can differ.
Official product documentation