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:
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!