C
Cameron
Hi,
I am working on a macro in excel that will take several series and plot them
on a scatter chart. Then the series will be made into a shape and filled in
with a certain color.
The problem I am having now is that when I try to make a small rectangle
(For instance the coordinates: (0,0) (0,0.2) (1,0.2) (1,0)) the shape builder
skips the third point and ends up making a triangle. This problem goes away
once the plot area is made larger, or the points aren't as close together.
The four points are plotted in the correct locations, but the shape builder
is not doing something right.
Here is the piece of code that I believe is giving me trouble;
Xnode = Xleft + (mySrs.XValues(Ipts) - Xmin) * Xwidth / (Xmax - Xmin)
Ynode = Ytop + (Ymax - mySrs.Values(Ipts)) * Yheight / (Ymax - Ymin)
myBuilder.AddNodes msoSegmentLine, msoEditingAuto, Xnode, Ynode
Thank you for your help,
Cameron
I am working on a macro in excel that will take several series and plot them
on a scatter chart. Then the series will be made into a shape and filled in
with a certain color.
The problem I am having now is that when I try to make a small rectangle
(For instance the coordinates: (0,0) (0,0.2) (1,0.2) (1,0)) the shape builder
skips the third point and ends up making a triangle. This problem goes away
once the plot area is made larger, or the points aren't as close together.
The four points are plotted in the correct locations, but the shape builder
is not doing something right.
Here is the piece of code that I believe is giving me trouble;
Xnode = Xleft + (mySrs.XValues(Ipts) - Xmin) * Xwidth / (Xmax - Xmin)
Ynode = Ytop + (Ymax - mySrs.Values(Ipts)) * Yheight / (Ymax - Ymin)
myBuilder.AddNodes msoSegmentLine, msoEditingAuto, Xnode, Ynode
Thank you for your help,
Cameron