Line missing in graph

[Sean]

Hi,
I'm trying to graph two data series on the same chart using a line graph.
The two data series are on the Y axis and are compared to time on the x axis.

I can get the data points to plot in the line graph, but the line connecting
the dots is missing. My hunch is it's dropping becuase there isn't
consectutive data values in the columns. Below is the datasheet extract from
the chart SQL.

Month Series A Series B
05-07 1
06-07 8
07-07 10
11-07 3
12-07 12.3 13.

If I plot this in Excel it has the same problem. When I fill in the blank
rows with the preceding value the line connects. Is there anyway to get the
chart to connect the dots without manipulating the data?
Thanks,
Sean

 

[Sean]

I found the answer in the Excel user's group.

I double clicked the graph in the Access report to bring up the Excel chart
toolbar. I went to Tools, Options, Chart. Then selected the "interpolated"
option.