I have the weekly chart below showing numbers 'weekly' for last 3 weeks.
When I change the ChartType to 'Monthly', it sums up the weeks numbers for that month and miscalulates the months (in the screenshot below I was expecting Nov & Dec but it shows Oct & Nov when I dont have numbers for Oct).
Also, on the 'Monthly' chart type, I want to show the last(latest) value for that month which would be 31857 & 6513 for Nov & 31955 & 6513 for Dec.
Any help would be appreciated.
Can you provide a sample workbook?