Posted to microsoft.public.excel.programming
|
|
Chart series delete all then add new
Thanks Andy
Andy Pope wrote:
Hi,
To remove all current series in a chart use,
do while activechart.SeriesCollection.count0
activechart.SeriesCollection(1).delete
Loop
cheers
Andy
keri wrote:
Hi,
I have a chart whose data series are deleted and re-populated. After
repopulating the data the series are all REF errors even though the new
data is the same and in the same place. So I need to write the code to
delete all the previous series so I can then re-add them through code.
Is this possible?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
|