J
Jeff
I am trying to automate through VBA a very tedious and
manual process of inputting the factors of the trendline
equation. I have tried two options and would be happy
with either, but have not been able to get them to work.
1) Is it possible to link a cell into the chart trendline
equation (I know I can copy and paste it, but I have about
50 of them to do)?
2) Or, how can I write some VBA code to copy and paste in
a cell the trendline equation. It doesn't seem to
recognize the chart when I record the keystrokes, and the
code I have written keeps getting errors as if it doesn't
recognize the chart when I put the chart name in -i.e.
With Charts("Chart 21").SeriesCollection(1).Trendlines(1)
.DisplayRSquared = False
.DisplayEquation = True
Worksheets("SAV Calib").Range("Q77").Value
= .DataLabel.Text
End With
Please let me know if anyone has any ideas! Thanks,
Jeff
manual process of inputting the factors of the trendline
equation. I have tried two options and would be happy
with either, but have not been able to get them to work.
1) Is it possible to link a cell into the chart trendline
equation (I know I can copy and paste it, but I have about
50 of them to do)?
2) Or, how can I write some VBA code to copy and paste in
a cell the trendline equation. It doesn't seem to
recognize the chart when I record the keystrokes, and the
code I have written keeps getting errors as if it doesn't
recognize the chart when I put the chart name in -i.e.
With Charts("Chart 21").SeriesCollection(1).Trendlines(1)
.DisplayRSquared = False
.DisplayEquation = True
Worksheets("SAV Calib").Range("Q77").Value
= .DataLabel.Text
End With
Please let me know if anyone has any ideas! Thanks,
Jeff