I am trying to create sectioned graphs using scatter plots. I need a macro
to be able to draw boxes for the particular areas on the graph using median
points which can change from graph to graph. I'm using the following code,
but I do not know how to tie these points to values in the graph. I can pull
over actual (x,y) from the data, but it needs to be converted into points or
pixels or whatever unit of measure the graphing tool is using. I basically
want a box that starts in the lower left @ (0,0) and goes to
(medianx,mediany) in the upper right and variations thereof. Any ideas?

myCht.Shapes.AddShape(msoShapeRectangle, Xleft, mySrs.Yvalues(Ipts),
Xwidth, Yheight - med1y).Select

The code on this page will show how to get the coordinates you need:

http://peltiertech.com/Excel/Charts/VBAdraw.html

This might be a better approach:

http://peltiertech.com/Excel/Charts/...ackground.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"ChadTarget" <(E-Mail Removed)> wrote in message
news5CF6555-B7B0-45F1-9AA2-(E-Mail Removed)...
>I am trying to create sectioned graphs using scatter plots. I need a macro
> to be able to draw boxes for the particular areas on the graph using
> median
> points which can change from graph to graph. I'm using the following
> code,
> but I do not know how to tie these points to values in the graph. I can
> pull
> over actual (x,y) from the data, but it needs to be converted into points
> or
> pixels or whatever unit of measure the graphing tool is using. I
> basically
> want a box that starts in the lower left @ (0,0) and goes to
> (medianx,mediany) in the upper right and variations thereof. Any ideas?
>
> myCht.Shapes.AddShape(msoShapeRectangle, Xleft, mySrs.Yvalues(Ipts),
> Xwidth, Yheight - med1y).Select