Excel Line Chart can't Plot

[Biz]

Hi,

I found an error when a line chart has only 1 data point to plot see first chart.
If I add same value for second month then it plots see second chart.

How to fix this situation?

I was thinking Error Bar with Point but I don't know how to do that.
Your help would be greatly appreciated.

Biz

 

[GraH]

Strange, the datapoint should appear with the marker

 

[Biz]

Yes, I realised it. It's, because 1 have only 1 data point then need to use "marker" to show data point. Normally, I use a line chart when greater than 1 data point to plot. Created a VBA custom function to add and remove markers based on number of data points and only for current year.

Thank you for your help. I spent very long time battling this problem.