- ·上一篇：excel表格链接怎么全部去除
- ·下一篇：excel表格有选项内容怎么看出来
excel表格怎么找回主坐标
2025-01-22 15:17:49
1.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