Chart trendline

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rwfreeman - 16 May 2008 18:47 GMT

What is the syntax to drill down to the Type property of
Graph.Trendline?

I have a form ("frmCompareAnalytes") that contains an MSGraph.Chart.8
scatter plot ("chrtCompareMetals") and I'd like to have the ability to
change the regression for the trendline (linear, logarithmic, power,
etc.). I seem to be syntacticly challanged and am wondering if
someone could light the path for me.

Thanks in advance.

Richard

Reply to this Message

Duane Hookom - 18 May 2008 03:43 GMT

I would create a similar chart in Excel. Turn on the macro record and make
the desired changes. Turn off the macro record and review the code. You can
often copy and paste the code into Access with just a few changes.

Signature

Duane Hookom
Microsoft Access MVP

> What is the syntax to drill down to the Type property of
> Graph.Trendline?
[quoted text clipped - 8 lines]
>
> Richard

Reply to this Message