Chart trendline

[rwfreeman]

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

 

[Duane Hookom]

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.