EXCEL散点图中怎么找点坐标

Sub XYAxis()

ActiveSheet.ChartObjects("Chart 1").Activate 选中 Chart 1

ActiveChart.Axes(xlValue).Select
With ActiveChart.Axes(xlValue)
.MinimumScale = ActiveSheet.[W83] 纵坐标最小值 W83为单元格
.MaximumScale = ActiveSheet.[w84] 纵坐标最大值
.MinorUnitIsAuto = True
.MajorUnitIsAuto = True

.Crosses = xlAutomatic
.ReversePlotOrder = False
.ScaleType = xlLinear
.DisplayUnit = xlNone
End With

ActiveChart.Axes(xlCategory).Select
With ActiveChart.Axes(xlCategory)
.MinimumScale = ActiveSheet.[W81] 横坐标最小值
.MaximumScale = ActiveSheet.[W82] 横坐标最大值
.MinorUnitIsAuto = True
.MajorUnitIsAuto = True

.Crosses = xlAutomatic
.ReversePlotOrder = False
.ScaleType = xlLinear
.DisplayUnit = xlNone
End With

End Sub

你把曲线拟合出来可以得到经验公式，有公式之后一切都解决了

重新下载个 office 已经损坏