Two charts can show exactly the same data and still create very different impressions. The difference often comes down to axis scaling.
If a value increases from 96 to 100, the change looks relatively small on a scale from 0 to 100. If that same axis starts at 90, the increase appears much more dramatic.
Axis scaling therefore affects more than the appearance of a chart. It directly influences how viewers interpret the data.
To manually adjust a value axis in PowerPoint:
The key settings in PowerPoint are Minimum, Maximum, Major unit, and Minor unit. Microsoft documents these options for the value, or Y, axis in PowerPoint for Microsoft 365 and current desktop versions.
Knowing where to change the settings is only the first step. The more important question is how to choose the right values.
No. The right choice depends on the chart type.
For column and bar charts, the value axis should generally start at zero. Bar and column length represents the magnitude of the values, so truncating the axis can make small differences look much larger than they really are.
For line charts, starting above zero can be appropriate when you want to highlight changes within a narrow range.
A truncated axis can be useful when it makes meaningful changes easier to see without creating a misleading impression of relative size.
Make the truncated range obvious. Keep the axis labels visible and show the actual starting value. If the scale is especially unusual, consider adding a brief note such as “Y-axis starts at 95.”
Effective axis scaling requires three key decisions.
For example, if your values range from €42 million to €48 million, an upper limit of 50 may work well. If PowerPoint automatically sets the maximum to 60 or 70, the extra space can make meaningful differences harder to see.
Choose the interval carefully too. Round increments such as 5, 10, or 20 are usually faster to understand than unnecessarily small or irregular intervals.
A well-scaled chart shows the range viewers need without wasting space.
A secondary axis is most useful when two related data series use different units or have very different value ranges, such as revenue in millions of euros and profit margin as a percentage.
In PowerPoint, select the chart and go to Chart Design > Change Chart Type. Choose a Combo (Mixed) chart and enable Secondary Axis for the appropriate data series.
Secondary axes are particularly useful when combining data series with different scales, including common column-and-line chart combinations.
However, a secondary axis is not always the clearest option.
Using two scales makes a chart harder to interpret. Before adding a secondary axis, consider whether a simpler approach can communicate the message.
Indexed values are useful when you want to compare the relative change in several metrics. For example, set both data series to 100 in the base year.
Small multiples work well when each metric needs its own scale but the trends still need to be compared over the same time period.
Separate charts with consistent formatting are often clearer when the data series do not need to appear in the same plot area.
A combo chart can also work well when different chart types help viewers distinguish the roles of the two metrics.
Use a secondary axis when two metrics belong together but cannot be displayed clearly on the same scale.
Different minimum and maximum settings can make two lines appear almost parallel even when their actual trends have little in common.
Do not use a secondary axis simply to make two data series line up visually. Label both axes clearly and ask whether the apparent relationship between the series would still be convincing without the chosen scaling.
The more your chart’s message depends on axis scaling, the more clearly that scaling should be communicated.
A single outlier can compress all the other values and make meaningful differences difficult to see. Using an extremely wide axis range is not your only option.
You can change the chart type, separate the overview from the detailed view, or use an axis break when appropriate. We cover effective uses of axis breaks in more detail in our article on charts with axis breaks.
When viewers need to compare several charts, use the same scale for the same metrics whenever possible.
If one chart uses a range from 0 to 100 while another uses 70 to 100, identical changes can look dramatically different. This is especially problematic in dashboards, plan-versus-actual comparisons, and comparisons across countries, regions, or business units.
Charts are visually comparable only when their scales are comparable.
For related charts, use consistent Minimum, Maximum, and Major unit settings. If you work with many charts, charting add-ins can help you apply consistent scales automatically or with fewer manual steps.
Do not choose an axis scale simply because it makes the chart look more dramatic. Set the zero baseline, axis range, and intervals so viewers can understand proportions and trends quickly, accurately, and without additional explanation.
When can a PowerPoint axis start above zero?
Primarily in line and trend charts when relatively small changes are the main focus. The actual starting value should always remain clearly visible.
What does Major unit mean in PowerPoint?
The Major unit controls the spacing between major tick marks and their corresponding gridlines on a value axis.
When should I use a secondary axis?
Use a secondary axis when two related data series have different units or such different value ranges that displaying them on a single scale would make the chart difficult to read.
Does the Y-axis in PowerPoint always have to start at zero?
No. For column and bar charts, a zero baseline is usually important because bar length represents relative magnitude. For line charts, starting above zero can be appropriate when the focus is on changes over time.