•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?
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.
[link] [comments]
Want to read more?
Check out the full article on the original site
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