I have two worksheets. One worksheets with source data and the other sheet ("Correlation Charts") is where I want the chart to be. Below is my code. However, it is still plotting the chart in the source data sheet instead of where I set the range to be.
Worksheets.Add.Name = "Correlation Charts"
Set myChart1 = Sheets("Correlation Charts").Range("A3:H16")
Worksheets("Summary").Activate
Application.Union(xValue1, yValue1).Select
With ActiveSheet.Shapes
.AddChart2(240, xlXYScatter, myChart1.Left, myChart1.Top, myChart1.Width, _
myChart1.Height).Select
End With
With ActiveChart
.ChartTitle.Text = Range("Correl1_yValue") & " " & "vs." & " " & Range("Correl1_xValue")
End With
With Sheets("Correlation Charts").Shapes
rather thanWith ActiveSheet.Shapes
– Rory