Skip to Content
Former Member
Oct 21, 2008 at 11:51 AM

Setting missing chart data to zero



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?

Many thanks...