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!xva lues,1) _
PlotBy:=xlColumns
With ActiveChart.SeriesCollection.NewSeries
.Values = Range(XValues)
.XValues = Range(YValues)
.name = "Sheet1"
End With


With ActiveChart

.HasTitle = True
.ChartTitle.Characters.Text = Application.VLookup(i,
Range("Graph"), 2) & " ppm vs Time "
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text =
"Date Time"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text =
Application.VLookup(i, Range("Graph"), 2) & " ppm"

End With