ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Chart vanishes! (https://www.excelbanter.com/excel-programming/325181-chart-vanishes.html)

rci

Chart vanishes!
 
Hi all...

deleting all series from a chart (using a loop) results in the chart itself
vanishing!

How can I prevent this so that I can clear then repopulate the series in a
chart without affecting the chart in any other way?

Thx,

SMS

Robin Hammond[_2_]

Chart vanishes!
 
Without more details of what you are doing I would have thought you just
avoid deleting all the series, and instead change the source data property
for the chart using SetSourceData.

Robin Hammond
www.enhanceddatasystems.com

"rci" wrote in message
...
Hi all...

deleting all series from a chart (using a loop) results in the chart
itself
vanishing!

How can I prevent this so that I can clear then repopulate the series in a
chart without affecting the chart in any other way?

Thx,

SMS





All times are GMT +1. The time now is 05:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com