How can I make the dates on the x-axis to appear only when there is number. In this example I only need jan 26th and feb1 to appear on x-axis not from jan 27th to 31st as there is no data. Please assist.
It looks like your date might be set to 'continuous' instead of 'discrete'. Right click on your date in the columns area, and click on discrete.
Retrieving data ...