Excel Chart link to Powepoint

Hey everyone,

As the title states it, I am facing an issue with linking a excel chart to a powerpoint slide.

I manually copy past the the chart to ppt.

When I need to update chart in excel, I run the following code:

Code:

---

For Each ch In Application.Charts        For Each ser In ch.SeriesCollection
            ser.Values = Range(Split(ser.Formula, ",")(2)).Resize(, i)
            ser.XValues = Range(Split(ser.Formula, ",")(1)).Resize(, i)
        Next ser
    Next ch

---

However, when I return on ppt, update the slide it doesn't work. I think the code has to somehow break the link.

Would you have some idea on how I could make it work?


Thanks a lot!