excel - 用户输入数据到图表上

Question

我想将用户输入值放在散点图上。我已经设法在代码中使用“Sheet1”让它工作，但实际上工作表选项卡会随着数字等而变化。

我可以在此代码中更改哪些内容以查看活动工作表？

'Add UserInput Data to Chart

ActiveChart.SeriesCollection.NewSeries
ActiveChart.FullSeriesCollection(2).Name = "=""min"""
ActiveChart.FullSeriesCollection(2).XValues = "=sheet1!$C$3,sheet1!$C$193"
ActiveChart.FullSeriesCollection(2).Values = "=sheet1!$E$3,sheet1!$E$3"

ActiveChart.SeriesCollection.NewSeries
ActiveChart.FullSeriesCollection(3).Name = "=""max"""
ActiveChart.FullSeriesCollection(3).XValues = "=sheet1!$C$3,sheet1!$C$193"
ActiveChart.FullSeriesCollection(3).Values = "=sheet1!$F$3,sheet1!$F$3"

标签： excelvbaexcel-charts