Sub 拟合4()
Dim s$
s = Worksheets("Sheet1").ChartObjects(1).Chart.SeriesCollection(1).Trendlines(1).DataLabel.Text
s = VBA.StrReverse(s)
s = VBA.Replace(s, "x", "z", , 1)
s = VBA.Replace(s, "x", "^x")
s = VBA.Replace(s, "z", "x", , 1)
Range("a1") = VBA.StrReverse(s)
End Sub
Sub 拟合()
Dim ser As Series
Set ser = Worksheets("Sheet1").ChartObjects(1).Chart.SeriesCollection(1)
s = ser.Trendlines(1).DataLabel.Text
s = VBA.Split(s, "=")(1)
s = VBA.Split(s, "x")
a = s(0)
b = Right(s(1), Len(s(1)) - 2)
c = Right(s(2), Len(s(2)) - 2)
d = s(3)
' Range("a1") = " =a * x ^ 3 + b * x ^ 2 + c * x + d" 'Y值
Range("a1") = " =" & a & " * x ^ 3 " & b & " * x ^ 2 " & c & " * x " & d 'Y值
Debug.Print a, b, c, d
End Sub
Sub 拟合3()
Dim s$
s = Worksheets("Sheet1").ChartObjects(1).Chart.SeriesCollection(1).Trendlines(1).DataLabel.Text
Range("a1") = VBA.Replace(s, "x", "x^")
End Sub
Sub 拟合4()
Dim s$
s = Worksheets("Sheet1").ChartObjects(1).Chart.SeriesCollection(1).Trendlines(1).DataLabel.Text
s = VBA.StrReverse(s)
s = VBA.Replace(s, "x", "z", , 1)
s = VBA.Replace(s, "x", "^x")
s = VBA.Replace(s, "z", "x", , 1)
Range("a1") = VBA.StrReverse(s)
End Sub