Interpolating on an Access Graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

notsodumbblonde - 28 Sep 2007 21:17 GMT

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.

Reply to this Message

AnandaSim - 29 Sep 2007 08:13 GMT

> 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:
[quoted text clipped - 8 lines]
> 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

Reply to this Message