Year-on-Year Graph with Month name as X-axis

[zacharylwy]

I've created a year-on-year chart that shows each year's performance on the same axis. I have a DateTable that has all the handy columns like "Date", "DayOfYear", "Month" etc. 

I can only format it and fit all data points as attached in the picture when the X-axis is DayOfYear. When I change to Month, it zooms in a lot and turns the graph into something that needs to be scrolled through.

I want to display the axis as Month (Jan, Feb,... or J, F, M, ...) . How do I do this and still have all datapoints fit/no need scroll

[Anonymous · Accepted solution]

Hi @zacharylwy ,

Based on the testing, if put the month on the X-axis and also display the daily values, that is, there will be a scroll bar, which is designed by the UI layout and cannot be removed. Because by putting both month and days, the line graph is not displayed completely there will be scrollbars.

Unless you don't add the month on the X-axis, then you can display the daily values without scrollbars.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[audreygerred]

Hi, when I have month number in my chart, it doesn't show a scroll bar - this is with the x-axis set as continuous

If I change it to categorical, it still doesn't show a scroll bar, but it does display each month number

I tried with abbreviations of month names and it still works:

Can you share a screenshot of what yours is doing?

[zacharylwy]

Also, I do not wish to show just the month totals (12 data points). I want to show the daily values (365/366 data points), same result as if I used "DayOfYear" just with month labels on the X axis.

[zacharylwy]

Ah my apologies, I left out a great deal of details.
I actually put both DayOfYear and Month in the X-axis...For some reason, "Month" alone does not work (nothing shows).

Then the graph with the above setting looks like this: