How to refresh a chart with a macro in Excel
Solved
val3ntin
-
Yoyo01000 Posted messages 1720 Registration date Status Membre Last intervention -
Yoyo01000 Posted messages 1720 Registration date Status Membre 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.
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 réponse
Hello,
to be placed in the sheet to refresh:
--
Remember to say "thank you" and "resolved" when the issue is resolved.
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.
val3ntin
Great, thank you for your response.
Yoyo01000
Posted messages
1720
Registration date
Status
Membre
Last intervention
168
>
val3ntin
If that is suitable, please mark the issue as [Resolved].