My pleasure.
To be more precise, i added just sleep before saving. 1700 milliseconds allow the chart load properly even on the most big data. You should choose the duration empirically
to be able using sleep function read thisCode:xlx.DisplayAlerts = False Sleep (1700) xlw.Close SaveChanges:=True xlx.DisplayAlerts = True
https://nolongerset.com/how-to-pause...rval%20elapses.