Thank you for the response. I'm already using datalabels in the chart, and
they're working properly. The shapes I'm talking about are tied to multiple
datapoints. Their purpose is to shade and label various sections of the
chart. I create the chart in a complex workbook with many sheets and large
VBA modules, then copy the one chart to a new workbook with no modules for
wider distribution. Some recipients just view the resulting chart on their
screen, others print the resulting chart in various paper sizes. Everything
resizes properly except these shapes. What's needed is a way to define
shapes with boundary points tied to data values rather than to pixel
locations.

Ken

"keepitcool" wrote in message
...

if it's "loose" shapes you're working with that's going to be a
nightmare :(

can't you use datalabels?

they're connected to the data and can be formatted/positioned relative
to the data they belong to.

have a look at the DataLabel object in vba help.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Ken Paul" wrote:

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.