Greetings,
1- Open enclosed file.
2- Run Macro1.
3- See that there will be a new sheet named Chart1.
But, I dont want a new sheet.
I want chart on "ChartSheet" sheet.
So, following code;
Sub Macro1()
Range("A1:A15").Select
ActiveSheet.Shapes.AddChart2(201, xlColumnClustered).Select
ActiveChart.SetSourceData Source:=Range("Sheet1!$A$1:$A$15")
ActiveChart.Location Where:=xlLocationAsNewSheet
End Sub
must be replace something like that;
Sub Macro2()
Range("A1:A15").Select
ActiveSheet.Shapes.AddChart2(201, xlColumnClustered).Select
ActiveChart.SetSourceData Source:=Range("Sheet1!$A$1:$A$15")
ActiveChart.Location Where:=Worksheets("ChartSheet")
End Sub
Red line must be corrected.
Best wishes.
Bookmarks