sorry Jon, the highlighted line should have been

ActiveChart.Location Whe=xlLocationAsObject

I agree it would be best to put the graph in the worksheet first, but
the macro is such that it will create a new report worksheet which
needs to create graphs on it.

But your code worked perfectly and better than I had expected as you
can use the myLeft etc parameters to position the graph exactly.

Many Thanks,
Tom


---
Message posted from http://www.ExcelForum.com/