View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
PeterQ
 
Posts: n/a
Default Want to place picture in top left corner of chart

Please ignore previous post - I was adding my picture object to the cell, not
to the chart object!


"PeterQ" wrote:

I am attempting to add an annotation to a chart using the copypicture
functionality. My problem is in precisely positioning the top-left corner of
the picture at the top-left corner of the plotarea.

The plotarea.insideleft property seems to return the offset of the left side
side of the y-axis. In Excel 2003 SP2, the
chart.axes(xlValue,xlPrimary).width property returns 0, so I can't work out
how to offset the picture precisely. Has anyone done this?

Thanks in advance..