Forum Discussion
Trying to add month and year labels underneath week numbers along x-axis in Excel graph
I have data throughout many years and am plotting them by week But I would like to add a month and year label underneath the week number like this example from https://community.fabric.micr...
If you have (or add) Year and Month columns to the source it shall work.
SergeiBaklan Thank you! Do you know how I can nicely format the months though? I've expanded my graph a lot, but even then the months show up sparsely and overlap with each other too much. I'd prefer it if the months were vertical to avoid this issue, but when I go to Format Axis > Text Options and set the text direction to "Rotate all text 270", it only rotates the week numbers.
Sparsity issue when graph is expanded:
Overlapping issue when graph is shrunk:
Is there any way to format the months so that they are vertical like the week numbers? Thanks!
In Excel we may rotate only most inner label, i.e. weeks in your case. Not others.
Keep values only for first date in month/year, slightly it could help with autoformatting