My chart is messed up. It's got an x axis of dates, almost every day over the last year has an entry. The y axis is a number from 1 to 4000. There are several data serieses.

If my x-axis is set to automatic, it makes a huge gap at both sides of the chart, going from far earlier to far later than the range of dates I've input.

So to work around this, I have to manually change the range to something sensible. Then I encounter a different problem - it needs me to input the date in what I presume is computerised date form, the number of days since 1900.

Does anyone know how to fix either of these two problems?