Hello,
Original Problem
I need to plot boxes to scale, hence using excel scatter plot and then using vba to fill the box
using code for fill shapes based on http://peltiertech.com/Excel/Charts/VBAdraw.html
similar code is available on multiple sites.
This works fine to take one shape at a time.
Currently, There is a need to merge two boxes into one shape so that they have uniform color and transparency. Is there a way to merge shapes. With the above could the two shapes are overlapping and there is a change in transparency in the overlap region.
You could use the sample data for verifying
Box1 Box2
x y x y
16 8 64 2
1024 8 4096 2
1024 72 4096 18
16 72 64 18
16 8 64 2
regards
Original Problem
I need to plot boxes to scale, hence using excel scatter plot and then using vba to fill the box
using code for fill shapes based on http://peltiertech.com/Excel/Charts/VBAdraw.html
similar code is available on multiple sites.
This works fine to take one shape at a time.
Currently, There is a need to merge two boxes into one shape so that they have uniform color and transparency. Is there a way to merge shapes. With the above could the two shapes are overlapping and there is a change in transparency in the overlap region.
You could use the sample data for verifying
Box1 Box2
x y x y
16 8 64 2
1024 8 4096 2
1024 72 4096 18
16 72 64 18
16 8 64 2
regards