Fill an area between 2 curves in an Excell chart?
 

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?

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/
_______


syseng wrote:

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?

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

"Jon Peltier" wrote:

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/
_______


syseng wrote:

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?

Hi,

2 ways,

activechart.Shapes.SelectAll
selection.delete

do while activechart.Shapes.Count 0
activechart.Shapes(activechart.Shapes.Count).Delet e
loop

Cheers
Andy

Ali Baba wrote:
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

"Jon Peltier" wrote:


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/
_______


syseng wrote:


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?


--

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

Thank you Andy



"Andy Pope" wrote:

Hi,

2 ways,

activechart.Shapes.SelectAll
selection.delete

do while activechart.Shapes.Count 0
activechart.Shapes(activechart.Shapes.Count).Delet e
loop

Cheers
Andy

Ali Baba wrote:
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

"Jon Peltier" wrote:


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/
_______


syseng wrote:


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?


--

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

Thanks Jon,

I will give this a try.

syseng

"Jon Peltier" wrote:

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/
_______


syseng wrote:

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?

Thanks Jon!

syseng

"Jon Peltier" wrote:

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/
_______


syseng wrote:

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?