Bar Chart Axis Max and Minimum

I could not replicate the problem. I have no trouble bringing up the format axis dialog and changing the axis minimum and maximum values.

Only two things come to mind:

1) Your sample file is a .xlsx file that cannot have macros in it. I'm assuming that this accurately represents your real file, but is it possible that your real file is macro enabled and has a macro that undoes your attempts to change?

2) While not usually with the format axis dialog, there are some dialogs where I occasionally find myself making changes, then clicking on the "cancel" rather than "OK" button to dismiss the dialog and lose my changes. Is it possible something similar is happening for you?

When you edit the max/min, exactly how are you editing the axis values? I know that my older version of Excel (should be the same in 2010, if you are still using 2010 as indicated by your profile) cannot accept "date" entries in the format axis dialog for a value axis. If I want the axis to start on 1 Jan 2022, I cannot enter "1/1/2022" or similar in the format axis dialog. I have to figure out the correct serial number outside of the dialog (usually I just enter the date into a spreadsheet cell formatted as fixed with 0 decimal places to get 44562), then I can enter the correct serial number in the format axis dialog.

I do not know if newer versions of Excel have fixed this limitation or not. I know that LO Calc is not limited in this way, but can readily accept date entries in its format axis dialogs.