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