how to show the last month on x-axis on chart?

[daveyc18]

beg month is nov 2019...last month is march 2021....i set the interval to 3 months, so i guess that's why the last month shows as feb 2021...is there anyway to always show the last and first month despite what interval you specify? unfortunately i dont see a min and max value like i do with the y-axis

 

[ravi2628]

beg month is nov 2019...last month is march 2021....i set the interval to 3 months, so i guess that's why the last month shows as feb 2021...is there anyway to always show the last and first month despite what interval you specify? unfortunately i dont see a min and max value like i do with the y-axis

Please Change the Label interval to 4 because you have totals months in the list is 17 so it is considering 3*5=15+2 so it is coming as Feb if you change to 4 it will Consider it as 4*4=16+1

 

[daveyc18]

tks for your reply ...I tried that but the data needs to be shown quarterly .......hmmm

 

[ravi2628]

tks for your reply ...I tried that but the data needs to be shown quarterly .......hmmm

Then You has to Represent the data in such a format.

 

[daveyc18]

how did u do that

 

[ravi2628]

how did u do that

First select the Data with month and remove the Month after your selection of graph

 

[daveyc18]

oh ....that may be a problem since I'm using a pivot table but I guess I could hide the month in the pivot table but then that means I would missing the data for that month on the graph