View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Embedded Chart locations

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.