G
Guest
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
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