S
sammy.peters
here is some code from a macro i am making. i would like it to make
an xy chart with my xvalues and yvalues range. these ranges are not
side by side.
as well this is usually creating seperate chart sheets not placing it
on the worksheet id like.
and where would i put .top,.left in this to properly place it.
thanks very much
Charts.Add
ActiveChart.ChartType = xlXYScatter
ActiveChart.SetSourceData
Source:=series(Assay_Solutionscrollzoomindynrange.xls!
xvalues,Assay_Solutionscrollzoomindynrange.xls!xvalues,1) _
PlotBy:=xlColumns
With ActiveChart.SeriesCollection.NewSeries
.Values = Range(XValues)
.XValues = Range(YValues)
.name = "Sheet1"
End With
an xy chart with my xvalues and yvalues range. these ranges are not
side by side.
as well this is usually creating seperate chart sheets not placing it
on the worksheet id like.
and where would i put .top,.left in this to properly place it.
thanks very much
Charts.Add
ActiveChart.ChartType = xlXYScatter
ActiveChart.SetSourceData
Source:=series(Assay_Solutionscrollzoomindynrange.xls!
xvalues,Assay_Solutionscrollzoomindynrange.xls!xvalues,1) _
PlotBy:=xlColumns
With ActiveChart.SeriesCollection.NewSeries
.Values = Range(XValues)
.XValues = Range(YValues)
.name = "Sheet1"
End With