+ Reply to Thread
Results 1 to 2 of 2

Want to place picture in top left corner of chart

  1. #1
    PeterQ
    Guest

    Want to place picture in top left corner of chart

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



  2. #2
    PeterQ
    Guest

    RE: 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..
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1