chart to be created in new sheet This macro creates chart in the worksheet same as da

[asdzxc]

This macro creates chart in the worksheet same as data. Plse add code so that chart can be created in new worksheet.
[VBA]Range("A4:C19").Select
ActiveSheet.Shapes.AddChart.Select ActiveChart.ChartType = xlLineMarkers ActiveChart.SetSourceData Source:=Range("'P11'!$A$4:$C$19") End Sub [/VBA]

[Bob Phillips]

Add this

[vba]
ActiveChart.Location xlLocationAsNewSheet[/vba]

[asdzxc]

your code added but: comile error;use of property at
xlLocationAsNewSheet
[VBA]ActiveChart.Location
xlLocationAsNewSheet
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SetSourceData Source:=Range("'P11'!$A$4:$C$28")
End Sub[/VBA]

[Bob Phillips]

You add it all in ONE line, AFTER your code. You cannot reference ActiveChart before there is one.

[asdzxc]

ok
thank you