I have a database that accumulates weather data.
One of the fields is a date field, and others are Rainfall, temp, humidity, etc.
Data is not entered on every date, there are therefore differences in time between successive sets of data.
When I create a PivotChart using date in the Category field and rainfall in the data field, a chart is created, but each date is equally spaced on the x-axis. What I want to create is x-axis spacing that is proportional to the true time between the dates entered. For example, if there is data every day for one week, but then a gap of 2 weeks this should be reflected in the spacing of the data poits on a line graph. Is there any way to do this without having empty data sets for the missing dates?