Arrange chart values by month
Posted: Tue Aug 11, 2020 6:14 am
Hello,
I have a dataset formed by a date and several values for that date. I want to display those values by the month of the date in a chart, showing the 12 months of the year and it's respective sumatory.
The problem I have is that I can either use the month number, so it arranges correctly but the labels are in numbers, or use the month name, so the labels are correct but it orders the data in alphabetical order of the month.
Also, only the months with data are shown but I would like to show all the months. Is there a way to do that?
Thank you so much!
I have a dataset formed by a date and several values for that date. I want to display those values by the month of the date in a chart, showing the 12 months of the year and it's respective sumatory.
The problem I have is that I can either use the month number, so it arranges correctly but the labels are in numbers, or use the month name, so the labels are correct but it orders the data in alphabetical order of the month.
Also, only the months with data are shown but I would like to show all the months. Is there a way to do that?
Thank you so much!