February 13, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Am I incredibly dumb or did Microsoft do really weird things with axis settings for charts?

Our take

If you've ever felt perplexed by Microsoft Excel's chart settings, you're not alone. Many users are grappling with the recent changes in Microsoft 365, particularly regarding axis formatting. The shift to requiring "Date" as the axis type—especially for adjusting bounds—has left many wondering if they've missed an update or simply lost their touch. Join us as we explore this new landscape, demystify the quirks of axis settings, and provide actionable insights to help you regain control over your charts without the frustration.

I'm trying to format two data sets on the primary and secondary vertical axes, each a function of the units on the horizontal axis. Should be easy enough. Except I can only set bounds if I select "Date" as the axis type, which must be a new development because none of the Excel videos on the internet show this. They all show the traditional axis options, as opposed to the three radio buttons for Automatic, Text, and Date that are shown in mine, the updated Microsoft 365.

I'm floored. Do I really need to treat the horizontal axis numbers like dates in order to format bounds? It's also doing incredibly strange things to the gridlines.

submitted by /u/BitcoinSaveMe
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

(Vent) Why is this program so awful?I have to use excel for work, I chart data and utilize these charts to show individuals progress, I'm told my chart needs some condition dividing lines to indicate when certain conditions changed so that the viewers of the data can see how these changes in conditions affect the metric of performance that I am measuring. All I need is to add in a vertical line on the graph with a little label above it. And then I just need to copy this over to a word document for the progress report. WHY IS THIS SO HARD? There's no options in chart options for this, ok lets look it up. "start by adding data points to your sheet for where you want your line to go-" STOP. Why would I ever want to add in data points to my sheet just to achieve an effect on a chart? I don't want anything but my data on the sheet. Eventually I accept that is the way I have to do it. Add the data points, set x to the date I want the line to show, set y to where it should be. Follow the video tutorial exactly. Nope, chart is now broken and unreadable. I try tweaking it to see if I can just get the data to show up right, no dice. Ok lets try the more impromptu way of adding lines by just adding shapes and grouping them with the chart so I can copy it over. Excel REFUSES to group more than 2 lines. I can manage to get one grouped but not the other for some reason and not the text boxes to label this. But the main point of this rant is just the question as to why I am having to do this at all? This program has existed for almost as long as modern computers. Excel should be capable of doing all the simple chart displays and adjustments without me having to jerry rig the solution. I get that utilizing all these smaller menus and data point tricks allows for more precision but my god I should be able to find an easy way to do this and not spend my whole afternoon chasing down something that works consistently! I guess ultimately my question is how do I add a simple vertical line on 2 dates in my chart but as a greater question why is this program the way it is? submitted by /u/SHjohn1 [link] [comments]

Tagged with

#Excel alternatives for data analysis#generative AI for data analysis#Excel compatibility#natural language processing for spreadsheets#rows.com#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#financial modeling with spreadsheets#Microsoft 365#axis settings#charts#horizontal axis#primary vertical axes#secondary vertical axes#bounds#Date#gridlines#axis type

Am I incredibly dumb or did Microsoft do really weird things with axis settings for charts? | Beyond Market Intelligence

Am I incredibly dumb or did Microsoft do really weird things with axis settings for charts?

Related Articles

Tagged with