I have a dataset from which I draw a line chart.
The data has a transaction date and a summary for purchases for each day.
When I draw a chart I need it to incorporate dates for days where there are no purchases and show these as zero. At the moment it appears to connect the two data points with a straight line. For example if the data has:
12 Oct - Sales £100
13 Oct - Sales £80
17 Oct - Sales £200
the line chart will just draw a line from the 13 Oct data point to the 17 Oct data point, when in reality the sales were £0 for the 14, 15 and 16.
I cannot modify the dataset to insert fake transactions with zero value for the missing days.
Can this be done?