View original (French)

How to refresh a chart with a macro in Excel

Solved
val3ntin -  
Yoyo01000 Posted messages 1720 Registration date   Status Member Last intervention   -
Hello,
I am looking to refresh a chart due to the data we are adding using the OFFSET function. And for that, I saw that we could use a macro. But I really don't know how to do it.
Would someone be kind enough to guide me to the solution please?
Thank you in advance.

1 answer

  1.
    Yoyo01000 Posted messages 1720 Registration date   Status Member Last intervention   168
     
    Hello,
    to be placed in the sheet to refresh: 

    Private Sub Worksheet_Activate() ActiveWorkbook.RefreshAll End Sub


    --
    Remember to say "thank you" and "resolved" when the issue is resolved.
    1
    1. val3ntin
       
      Great, thank you for your response.
      0
      1. Yoyo01000 Posted messages 1720 Registration date   Status Member Last intervention   168 > val3ntin
         
        If that is suitable, please mark the issue as [Resolved].
        0