Hi

I have a problem creating a chart on a sheet in a workbook.

.ActiveChart.Location(xlLocationAsObject,"Summary Source")

should create the chart on the sheet titled "Summary Source". This is the second sheet of four.
But the chart is being created on the first sheet

I tried selecting the sheet with

.Sheets("Summary Source").Select

and in Excel that is showing as the selected sheet but the chart still goes on the first sheet.

Any ideas what I am doing wrong.

Thanks

Nick Mason