Chart: show all dates even if no data for these

[zico8]

Is it possible to create line chart in excel with all dates included in axis X even if my data does not have any value for particular day?

 

[steve the fish]

Right click axis. Format axis. Make sure type set to date

 

[zico8]

Thanks,

But probably I did not explain it correctly.

For example my data contains:
2018-05-14 23
2018-05-15 87
2018-05-17 93

I would like to have on the axix also 2018-05-16 (with 0 value) even if I do not have this date in my data table.

 

[steve the fish]

I stand to be corrected but i think you will need to add a date with a zero in your data.