The ChartObject is the container for a chart on a worksheet.
Returns a range object...
Worksheets("Sheet1").ChartObjects(1).TopLeftCell
Returns a chart...
Worksheets("Sheet1").ChartObjects(1).Chart
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"WhytheQ"
wrote in message
Quick question:
How do embedded charts relate to the sheet they are in?
What I'm trying to do is find out the cell above the top edge of a
graph so that I can insert some narrative there.
Any help greatly appreciated,
Jason.