View original (French)

Update the charts in a PowerPoint.

Solved
tomexcel -  
 tomexcel -
Hello everyone, and thank you in advance for your help:

I have an Excel file containing charts that I exported to PowerPoint (thinking to link the data)
when I modify my data, the charts on both Excel and PowerPoint update without problems
However, once I close PowerPoint and reopen my PowerPoint file, and repeat the operation, the PowerPoint charts do not update anymore (and I have to manually "refresh the data" for each chart, but my PowerPoint contains many, many charts.)
Can you help me solve this problem?

1 answer

  1.
    Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    Hello.

    Do these different graphs each come from a distinct data table,
    or are they various illustrations of a single table?

    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
    1. tomexcel
       
      Hello Mr. PENTIER, thank you for taking the time to help me, but someone from outside has already assisted me!
      If you are interested, or if a future person in need passes by here:
      My charts come from data on the same sheet, but this data varies depending on the charts used.
      I'm sharing the tip that was given to me:
      you just need to create a macro (in PowerPoint) that allows you to update all the charts, which we will need to integrate into a button to be pressed during the presentation.
      Here is the macro:

      Sub UpdateCharts()
      Dim sld As Slide
      Dim sh As Shape
      For Each sld In ActivePresentation.Slides
      For Each sh In sld.Shapes
      If sh.HasChart Then
      If sh.Chart.ChartData.IsLinked Then sh.LinkFormat.Update
      End If
      Next
      Next
      End Sub

      Have a great day!
      3