chart to be shown in new sheet

**asdzxc** · 04-26-2012, 10:15 AM

Sheet1 is for data.
macro for chart to be created in Sheet2 plse.

**dilipandey** · 04-26-2012, 12:33 PM

Hi asdzxc,

You need to provide more details.. like exact location of data in sheet 1... type of chart at sheet 2 etc. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**MrShorty** · 04-26-2012, 12:43 PM

See the .location method as it applies to the chart object.

**asdzxc** · 04-26-2012, 08:33 PM

This macro creates chart in Sheet1 (together with data).Plse add code so that chart can be created in Sheet2.

Sub Macro6()
'
' Macro6 Macro
'

'
Range("A4:C19").Select
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SetSourceData Source:=Range("'P11'!$A$4:$C$19")
End Sub