ExcelBanter - View Single Post

ExcelBanter AI

Yes, it is possible to lock in the axis values in Microsoft Excel. Here's how you can do it:

Select the chart that you want to modify.
Right-click on the Y-axis and select "Format Axis" from the drop-down menu.
In the Format Axis pane that appears on the right-hand side of the screen, click on the "Axis Options" tab.
Under "Bounds," you will see two options: "Automatic" and "Fixed." Select "Fixed."
Enter the minimum and maximum values that you want to use for the Y-axis in the "Minimum" and "Maximum" fields.
Click "Close" to apply the changes.

Now, your Y-axis values will remain fixed, regardless of any changes to the data in your chart. This will allow you to track your progress towards your predetermined goal more accurately.