How do I add a chart to he active worksheet? It always makes a new sheet.

Thanks

In the code where you are creating the chart, use a .Location statement to
tell Excel to place the chart as an object on a specified sheet (in this case
the active sheet). For example,

Dim sht As String
sht$ = ActiveSheet.Name
Charts.Add
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData _
Source:=Sheets(sht$).Range("A5:E26"), PlotBy:=xlColumns
ActiveChart.Location Whe=xlLocationAsObject, Name:=sht$

Hope this helps,

Hutch

"Sandy" wrote:

How do I add a chart to he active worksheet? It always makes a new sheet.

Thanks

Step 4 of the chart wizard asks you where you want the chart to land. Ensure
that it is object in ??? sheet and not as new sheet...
--
HTH...

Jim Thomlinson


"Sandy" wrote:

How do I add a chart to he active worksheet? It always makes a new sheet.

Thanks

Tom, Thankyou - worked perfectly.

Can you tell me how to place the chart on the sheet where I want it?

Thanks again,

Sandy

"Tom Hutchins" wrote:

In the code where you are creating the chart, use a .Location statement to
tell Excel to place the chart as an object on a specified sheet (in this case
the active sheet). For example,

Dim sht As String
sht$ = ActiveSheet.Name
Charts.Add
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData _
Source:=Sheets(sht$).Range("A5:E26"), PlotBy:=xlColumns
ActiveChart.Location Whe=xlLocationAsObject, Name:=sht$

Hope this helps,

Hutch

"Sandy" wrote:

How do I add a chart to he active worksheet? It always makes a new sheet.

Thanks