Hi Manoj,

It is possible to show January to December when value is zero or null but you should have date in your data.

In your Data, You have only two date. And May is showing just because of it's in between of April and June.

Please mark correct and helpful if you get this.

Best-

Suman

Hello Manoj

I created another sheet with just "Month" information from Jan to Dec.

I used this sheet to right joined with your data

And finally I showed this data on graph

PLEASE MARK IT AS CORRECT ANSWER IF SOLVES YOUR QUERY

Here is one idea.

Show missing value is only effective between min and max of existing.

Then,

Change x-axis date to continuous month.

20 is appropriate to keep 10 days gap between month.

Thanks,

Shin

HI Manoj,

Sorry, I am not sure about your expectation/question.

Please attach illustrations to explain the issue, expectations.

Thanks,

Shin

2. Need to include Year in X-axis

How?  please add illustrations.

Shin

Hope this helps.

If series of posts helped, please mark my answer as correct / helped to close the thread, not from inbox but from original post.

Thanks,

Shin

Hi Manojkumar

You are welcome.

Please mark my answer as correct / helped to close the thread, not from inbox but from original post.

Thanks,

Shin

Plz Check below answer