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