Thanks a lot for your quick response.
I am aware of the solution you have shared but my desired target is x axis completely showing no March data from your workbook.
Instead i wanted Jan feb Apr may........and the marks also displaying similar style.
I am sorry I am not sure what you are expecting.
Could you illustrate your required view?
Please see attached.
I wanted missing months not to be displayed in X axis at all INSTEAD a space should be added where its missing so that gap is maintained.
In my case missing month "Mar'17" should vanish from X axis since there is no data for it and leave a trace of it by a blank space.
Also manually hiding the month will again readjust the size.
Spacing Trends graph.twbx 23.3 KB
2 of 2 people found this helpful
Just on idea.
I don't think you can modify x-axis in any case.
In instead, added 2nd axis with bar as transparent color with synchronizing as number "-5" as MIN.
-5 is just picked because it's proper height of Y-axis
Then add "month" on bar chart.
Hide "negative" value from primary chart.
Thanks a lot!
You are welcome.