Shading inbetween two sets of values on a graph using VBA

[Sara.]

Hi,

I was wondering if it was possible to shade between two separate series of values on a graph using VBA? I know how to shade left using this link-- http://peltiertech.com/Excel/Charts/VBAdraw.html , but I can't get any code to work correctly for shading inbetween two series.

Sara

 

[Steve=True]

He provides a non-vba way to do this:

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


Alternately, can you use VBA to fudge the 2 series by using a polygon and fill between?

That would be the same in my mind.