G
Guest
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..
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..