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]