Interpolating on an Access Graph

[notsodumbblonde]

I am trying to create a graph in ACCESS that will continue a trend line even
if there is not data at a data point. For instance:
Sig 1 Sig 2 Sig 3

1 1 1 1
2 1 1
3 1 1
4 1 1
5 1 1 1
Som entries have no data and I cannot enter any data as that would be
incorrect. I know in Excel you can choose "Interpolated" under Chart
Options, but I can't find anything even close in ACCESS.

 

[AnandaSim]

I am trying to create a graph in ACCESS that will continue a trend line even
if there is not data at a data point. For instance:
Sig 1 Sig 2 Sig 3

1 1 1 1
2 1 1
3 1 1
4 1 1
5 1 1 1
Som entries have no data and I cannot enter any data as that would be
incorrect. I know in Excel you can choose "Interpolated" under Chart
Options, but I can't find anything even close in ACCESS.

AFAIK the Graph in Access is a cut down, chopped up version of Excel's
chart feature.
Why not export the data to Excel and use Excel's features?

HTH
Ananda