If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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.. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I place a different picture watermark on each text page? | Ian Murray | General Discussion | 3 | April 25th, 2006 08:22 PM |
Background picture behind chart | RalphB | Charts and Charting | 7 | November 17th, 2005 12:43 PM |
No returned records on Subform. | The Shaker | Using Forms | 5 | September 13th, 2005 06:08 PM |
move y-axis labels on column chart from left to right side | Kaye | Charts and Charting | 3 | June 3rd, 2005 12:59 PM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |