Excel - xy plot fill plotted rectangle

Hi,

Do any new versions of excel have the ability to plot the four corners of a
rectangle on an XY scatter plot, i.e. five pairs of coordinates (x1y1, x1y2,
x2 y2, x2y1, and to close the box x1y1), and then "fill" the rectangle with a
colour of my choice, or any polygon defined by the vertices.

I know an old product by Corel (quattro pro?) used to be able to do this.

Thanks
Mark

It is a long process but see
http://peltiertech.com/Excel/Charts/XYAreaChart.html
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Mark" wrote in message
...
Hi,

Do any new versions of excel have the ability to plot the four corners of
a
rectangle on an XY scatter plot, i.e. five pairs of coordinates (x1y1,
x1y2,
x2 y2, x2y1, and to close the box x1y1), and then "fill" the rectangle
with a
colour of my choice, or any polygon defined by the vertices.

I know an old product by Corel (quattro pro?) used to be able to do this.

Thanks
Mark

Hi Bernard,

I think I looked at this quite a while back (years?), however, I don't think
it accomplished what I needed, as I need to fill not just one rectangle on an
XY plot, but potentially hundreds that are not aligned vertically.

If I remember, this technique wouldn't work for more than a single shaded
area. Please let me know if I am missing something.

"Bernard Liengme" wrote:

It is a long process but see
http://peltiertech.com/Excel/Charts/XYAreaChart.html
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Mark" wrote in message
...
Hi,

Do any new versions of excel have the ability to plot the four corners of
a
rectangle on an XY scatter plot, i.e. five pairs of coordinates (x1y1,
x1y2,
x2 y2, x2y1, and to close the box x1y1), and then "fill" the rectangle
with a
colour of my choice, or any polygon defined by the vertices.

I know an old product by Corel (quattro pro?) used to be able to do this.

Thanks
Mark

Hi,

VBA is your only option given the number of fills you will require.
http://peltiertech.com/Excel/Charts/VBAdraw.html

Cheers
Andy

Mark wrote:
Hi Bernard,

I think I looked at this quite a while back (years?), however, I don't think
it accomplished what I needed, as I need to fill not just one rectangle on an
XY plot, but potentially hundreds that are not aligned vertically.

If I remember, this technique wouldn't work for more than a single shaded
area. Please let me know if I am missing something.

"Bernard Liengme" wrote:


It is a long process but see
http://peltiertech.com/Excel/Charts/XYAreaChart.html
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Mark" wrote in message
...

Hi,

Do any new versions of excel have the ability to plot the four corners of
a
rectangle on an XY scatter plot, i.e. five pairs of coordinates (x1y1,
x1y2,
x2 y2, x2y1, and to close the box x1y1), and then "fill" the rectangle
with a
colour of my choice, or any polygon defined by the vertices.

I know an old product by Corel (quattro pro?) used to be able to do this.

Thanks
Mark



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi,
Thank you for your help. I have a functioning pice of code now that works to
my specifications with some alterations.

I ran into a problem when I would try to fill a rectangle where the hieght
is small. For instance when the difference between the y-coordinates is less
than 0.38, the third point will be skipped and a triangle is formed instead
of a rectangle. The markers from the points are correct, but for some reason
the code doesn't connect a line to all of the points.

Thank you for you help,


"Andy Pope" wrote:

Hi,

VBA is your only option given the number of fills you will require.
http://peltiertech.com/Excel/Charts/VBAdraw.html

Cheers
Andy

Mark wrote:
Hi Bernard,

I think I looked at this quite a while back (years?), however, I don't think
it accomplished what I needed, as I need to fill not just one rectangle on an
XY plot, but potentially hundreds that are not aligned vertically.

If I remember, this technique wouldn't work for more than a single shaded
area. Please let me know if I am missing something.

"Bernard Liengme" wrote:


It is a long process but see
http://peltiertech.com/Excel/Charts/XYAreaChart.html
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Mark" wrote in message
...

Hi,

Do any new versions of excel have the ability to plot the four corners of
a
rectangle on an XY scatter plot, i.e. five pairs of coordinates (x1y1,
x1y2,
x2 y2, x2y1, and to close the box x1y1), and then "fill" the rectangle
with a
colour of my choice, or any polygon defined by the vertices.

I know an old product by Corel (quattro pro?) used to be able to do this.

Thanks
Mark



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info