PowerPoint Chart Axis Min, Max, and Major Unit: How to Lock

When you create a chart in PowerPoint and set specific minimum, maximum, or major unit values on the axis, you expect those settings to stay. But often after you close the presentation or edit the data, the axis resets to automatic values. This happens because PowerPoint recalculates axis bounds each time the data changes or the file is reopened. In this guide, you will learn how to lock the axis minimum, maximum, and major unit values in a PowerPoint chart so they remain fixed regardless of data updates.

Why PowerPoint Resets Axis Minimum, Maximum, and Major Unit Values

PowerPoint charts are linked to an underlying data source, typically an Excel worksheet embedded in the slide. By default, the chart axis bounds are set to “Auto,” meaning PowerPoint scans the data range and calculates the minimum, maximum, and major unit dynamically. This is useful when data changes frequently, but it becomes a problem when you want a consistent visual scale.

When you manually type a value into the Minimum, Maximum, or Major Unit box, PowerPoint immediately applies that value. However, the setting is not permanently locked. If you close the presentation and reopen it, or if you edit the data in the linked worksheet, PowerPoint may reset those fields back to Auto. This behavior is by design — the chart engine treats manual entries as suggestions rather than locked rules.

The root cause is that the axis bounds are stored as part of the chart’s formatting properties, but they are not protected from being overwritten by the automatic recalculation process. The only way to enforce your values is to ensure the “Auto” checkbox is unchecked for each axis property. This article shows the exact steps to lock these values so they survive saves, closes, and data edits.

Steps to Lock Axis Minimum, Maximum, and Major Unit in PowerPoint

Follow these steps to set and lock the axis values on any PowerPoint chart. These instructions apply to PowerPoint for Microsoft 365, PowerPoint 2021, and PowerPoint 2019.

1. Select the chart and open the Format Axis pane
   Click on the chart to select it. Right-click the vertical axis (the value axis) and choose Format Axis from the context menu. The Format Axis pane opens on the right side of the PowerPoint window.
2. Navigate to Axis Options > Bounds
   In the Format Axis pane, make sure the Axis Options icon (a bar chart icon) is selected. Expand the Bounds section. You will see two text boxes: Minimum and Maximum.
3. Enter the desired Minimum value
   In the Minimum text box, type the numeric value you want as the lowest point on the axis. For example, type 0 if you want the axis to start at zero. After typing, press Enter. The chart updates immediately.
4. Enter the desired Maximum value
   In the Maximum text box, type the numeric value you want as the highest point on the axis. For example, type 100 to cap the axis at 100. Press Enter to apply.
5. Set the Major Unit value
   Below the Bounds section, expand the Units section. In the Major text box, type the interval you want between gridlines and tick marks. For example, type 10 to have a gridline every 10 units. Press Enter.
6. Verify that Auto checkboxes are cleared
   After typing a value, the Auto checkbox next to that field becomes unchecked. If the checkbox remains checked, click the checkbox to clear it. This is the step that locks the value. Repeat for Minimum, Maximum, and Major Unit.
7. Close the Format Axis pane
   Click the X in the top-right corner of the Format Axis pane to close it. The axis values are now locked. Save the presentation to preserve the settings.

To confirm the lock is working, close the presentation, reopen it, and right-click the axis to open the Format Axis pane. The Minimum, Maximum, and Major Unit fields should still show your typed values, and the Auto checkboxes should remain unchecked.

Common Issues When Locking Axis Values and How to Fix Them

Axis values reset to Auto after reopening the presentation

If you set the values and save the file, but the axis resets to Auto when you reopen, the chart may be linked to an external Excel workbook. When PowerPoint reconnects to the external data source, it recalculates the axis. To prevent this, break the link by converting the chart to a static image, or paste the chart as a picture. However, this removes the ability to edit the chart data. A better solution is to ensure the Auto checkboxes are unchecked before saving. If the problem persists, try opening the file in PowerPoint for Microsoft 365 and checking the axis settings again.

Cannot type a value in the Minimum or Maximum box

The text boxes may be grayed out if the axis type is not set to a numeric scale. For example, a text-based category axis does not have numeric bounds. Ensure you are selecting the value axis, not the category axis. The value axis is typically the vertical axis on a column chart or the horizontal axis on a bar chart. If you are using a chart type like a pie chart, there is no value axis to lock.

Major Unit value does not match the gridlines on the slide

If you set Major Unit to 10 but the gridlines still appear at intervals of 5, the chart may have a secondary axis with different settings. Check whether your chart has a secondary vertical axis. Right-click the secondary axis and apply the same locked values. Also verify that the chart type supports major unit customization — some chart types like stock charts have fixed intervals.

Axis Lock Methods: Manual Entry vs VBA vs Copy Formatting

Item	Manual Entry in Format Axis Pane	VBA Macro	Copy Chart Formatting
Description	Type values directly and clear Auto checkboxes	Use a macro to set axis properties programmatically	Copy a chart with locked axes and paste formatting onto another chart
Ease of use	Simple, no coding required	Requires VBA knowledge and enabling macros	Moderate, requires a source chart with correct settings
Persistence across sessions	Works if Auto boxes are unchecked	Must run macro each time or attach to workbook open event	Applies formatting only, data must be updated separately
Best for	One-time setup on a few charts	Large presentations with many charts needing uniform axes	Quickly applying axis formatting from a template chart

Manual entry is the recommended method for most users because it requires no additional tools and the settings remain locked after you clear the Auto checkboxes. VBA provides automation but adds complexity. Copying chart formatting works only if the source chart already has locked axis values.

You can now lock the axis minimum, maximum, and major unit values in any PowerPoint chart. These settings will stay the same even when you edit the underlying data or reopen the file after several days. For presentations that require consistent scaling across multiple slides, consider creating a chart template with locked axis values and applying it to each chart using the Format Painter or the Chart Design tab. A final tip: if you need to unlock the axis later, open the Format Axis pane and click the Reset button next to each bound value to revert to automatic mode.