Access 2002 Chart

[Access Chart dummy]

Hi. I inserted a scatter plot chart on a blank form, using
chart wizard. All the data points display just fine.
However, I want a line to connect 2 data points on the
same series. I changed the markers to have a line.
However, since the 2 data points are not in a sequence,
e.g. 1st data point = 6, 8 (where 6 is for x-axis, and 8
is for y-axis) and 2nd data point = blank, 3rd data point
= 10,10. So, the chart won't show the line connect data
point 1 and 3 without data for 2nd data point. Is there
any suggestions?

Thanks in advance!

 

[Van T. Dinh]

1. Double-click on the Chart object to open Microsoft
Graph.

2. Use the MS Graph Menu Tools / Options ... / Chart tab
and in the "Empty Cell plotted as " pane,
select "Interpolated".

3. OK a few time to accept / save.

HTH
Van T. Dinh
MVP (Access)