1 min readfrom 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?

https://preview.redd.it/x0pyzsflj26h1.png?width=752&format=png&auto=webp&s=b911b3b67947e09536bb74fd4232de844b8e2c2d

https://preview.redd.it/9sfimd4mj26h1.png?width=525&format=png&auto=webp&s=9b510249f2a015f48d830081f878605b64474ab5

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com