automatic drawing of shapes (areas) into graphs based on data values?

[77anders]

Hi,
Is there a way with a macro to draw and colorize areas of the graph?

For example: part of an area under the curve) with a coloured shape?

The idea is to display the integral of a curve in an easy way.

[77anders]

I found the solution on the web.
HAve a look at this link I you've the same problem. They've got a lot of good excel tips!

http://peltiertech.com/Excel/Charts/VBAdraw.html

[shg]

See also Excel Chart God Andy Pope's site: http://andypope.info/

[77anders]

THanks for the link. A lot of good plotting tips there as well!