LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Shapes with boundaries tied to chart data points

I have added several shapes to a standalone chart (in VBA) with the boundary
points defined as data values converted to points in chart coordinates.
Though this looks great on the screen, the boundaries are way out of place
when I resize / reshape the window or print the chart. Is there a way to
tie shape boundaries to coordinates on the chart so that the shape maintains
its relationship to the chart when the window is resized / reshaped or the
chart is printed? I'm using Excel 2002.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart and Data points MCook Charts and Charting in Excel 0 September 11th 09 09:49 PM
I need to chart some data points! gford Charts and Charting in Excel 5 September 25th 08 04:04 PM
Data Points in Chart Mike Excel Discussion (Misc queries) 4 February 23rd 07 01:20 PM
excel positioning in Points for vba shapes Kelzina Excel Worksheet Functions 1 November 15th 06 02:22 PM
tough problem - working out if data is within certain boundaries phillip harrison Excel Programming 4 July 17th 03 05:53 PM


All times are GMT +1. The time now is 02:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"