It's baffling that a simple formatting task, setting bounds on two data sets plotted against a horizontal axis, turns into a hunt for hidden menus. The user who shared this frustration is not alone. They followed the logic: select the axis, adjust the bounds, move on. Instead, they discovered that in the latest version of Microsoft 365, the only way to set those bounds is to classify the horizontal axis as "Date." The old options are gone. The internet's collective knowledge, years of tutorials, forum posts, and video walkthroughs, is suddenly irrelevant. That is not progress. That is a regression disguised as an update.
This is what happens when software designers prioritize backend architecture over real-world workflows. The user's horizontal axis contains numbers, not dates. Forcing them to treat those numbers as dates to access basic formatting controls is a design failure. It breaks the mental model that makes spreadsheets useful: that you can plot numbers against numbers, cleanly and predictably. The user notes that the gridlines also behave strangely under this new regime. That is not a quirk. It is a symptom of a system that no longer respects the user's intent. When the tool stops aligning with the task, the tool becomes the obstacle.
For anyone who manages data day-to-day, this story hits close to home. You rely on your spreadsheet to be predictable. You need it to do what it has always done, because your work depends on consistency. When an update silently removes a standard option, and the only workaround is a hack that treats numbers like dates, you lose trust. That trust is hard to earn back. The user in this story is not asking for something exotic. They want to format two series on two vertical axes, with clean bounds on the horizontal axis. That is a basic request. That it now requires a workaround is a sign that the tool has drifted away from the people who use it.
The takeaway is simple: when your tool makes simple tasks feel like puzzles, it is time to explore simpler data tools. Not because you lack skill, you clearly know what you need. But because the software should adapt to you, not the other way around. The user here is resourceful: they searched videos, tested settings, and identified the problem. That effort should not be necessary for a task this straightforward. Spreadsheets should empower you to focus on your data, not on decoding the interface. If your current tool forces you into a corner, look for one that meets you where you are.