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 Where:=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 Where:=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