•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
x axis not formated as dates
Hello,
I have the following chart. On the x-axis, it uses every row from the table where I have a date (which is correctly formatted as a date). Since I'm starting to have too much data, I would like it to display, for example, only one tick mark per month (e.g., on the first day of each month). However, in the axis formatting options, it does not offer the usual unit tab with tick interval settings.
Could you help me with this?
[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
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#row zero
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#x-axis
#date formatting
#tick interval