Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
text typed across columns vanishes at a certain point...it's a dead zone! | Excel Discussion (Misc queries) | |||
Function Arguments dialog vanishes when clicked an inserted shape | Excel Worksheet Functions | |||
Excel data randomly vanishes | Excel Discussion (Misc queries) | |||
copy vanishes | New Users to Excel | |||
Pivot Table vanishes when refreshed | Excel Worksheet Functions |