Chart doesn't refresh after VBA rebuild

Hi,

I hav a big problem with a chart, what is damaged after using a SAP ADD IN. This ADD IN is a must be. So I have no other chance to rebuild the chart by VBA.
Wht I do is :
- get the chart as object
- delete the seriescollection
- rebuild it with new seriescollections.

However, what I get is al blank plot area and no table beyond. The marveles thing is, after closing Exccel an open it the chart ist shown correctly.
Thank you for looking, thinking and probably helping.

Please don't mind my terrible English. What I do is :

Please Login or Register  to view this content.

Unfortunatly not, when I delete this line nothing happens.

But I've changed the code a bit. I do not delete all of seriesCollection. I leave one. Build my SeriesCollection new and delete the obsolete one after that.
The result ist funny: Excel is showing now the plotArea, but not the DataTable beyond. The Data Table is very comprimized left and top of the screen. I haven't found any command to refresh the DataTable yet.
Data Table.png

After Closing Excel and reopen it everything is fine again.

Sorry, but save does not work also.

Thank you Andy, i have tried

Please Login or Register  to view this content.

)

Does not work.

And

Please Login or Register  to view this content.

did not work either.

If the problem started when you began to use the add-in then maybe it is switching off some important stuff in the application object...

Have you tried including

Please Login or Register  to view this content.

Thank´you coolblue,

yes I've tried this as well without success.

Hello friends of VBA, the statement what is damaging my DataTabel is

Please Login or Register  to view this content.

Hi xlbiznes,

sorry this is not possible. Because of company secrets.
What I try now ist to kill that beast of chart and create it brand new...

To be continued....

@xlbiznes

Sorry, I try to include this statement. But it doesn't work, because I'Ve been asked to declare "Source". Btw : Object Chart do not support Method ADD. Where is my wrong thinking?