Fill an area between 2 curves in an Excell chart?

[Guest]

I created an excell x-y chart that has 4 curves on it. Is it possible to
select 2 of the curves and shade the area between them?

 

[Jon Peltier]

You can do it with an area chart, or by adapting this VBA technique:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

Hi Jon

I used your technique and it worked but how do I clear the shapes if I want
to plot something else. I know this can be done by selecting the shapes then
delete but is there a way to write VBA to clear them with a click of a
button??

thanks

 

[Andy Pope]

Hi,

2 ways,

activechart.Shapes.SelectAll
selection.delete

do while activechart.Shapes.Count > 0
activechart.Shapes(activechart.Shapes.Count).Delete
loop

Cheers
Andy

 

[Guest]

Thank you Andy

Hi,

2 ways,

activechart.Shapes.SelectAll
selection.delete

do while activechart.Shapes.Count > 0
activechart.Shapes(activechart.Shapes.Count).Delete
loop

Cheers
Andy

 

[Guest]

Thanks Jon,

I will give this a try.

syseng

You can do it with an area chart, or by adapting this VBA technique:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

Thanks Jon!

syseng

You can do it with an area chart, or by adapting this VBA technique:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______