Hi,
I have a pivot table starting from Aug 2018 to July 2020.
Now i want to plot the data in bar chart while they are filtered by years.
x-axis will be month and y-axis values.
Problem is that depending on the selected/filtered year, the months in axis changes.
For example, in 2018 it shows from Aug to Dec while in 2019, from Jan to dec.
I wish to fix axis range to Jan - Dec no matter which year is selected.
Please advise how i can fix.
Regards
Minki
Bookmarks