| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart series delete all then add new
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Chart series delete all then add new
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 |
|
#3
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
| how to plot column chart with one series against multiple series. | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
| Chart, Series delete event | Charts and Charting in Excel | |||
| Chart, series delete event over context menue | Charts and Charting in Excel | |||
Linear Mode
