Clear all charts using vba

[paula.mccall]

Hello,

I am practicing and learning how to incorporate codes that will create charts in my worksheet(s). I believe I have found a working code to create the charts, but I wanted to know if anyone could provide me a code to delete or refresh the charts, so when I update the data, I can also update the charts. I have attached an example workbook. I appreciate any help that can be provided.

Kind Regards,
Paula M

[Artik]

Please Login or Register  to view this content.

Artik

[paula.mccall]

Hello Artik,

I really appreciate your help and time. I added your code to the workbook, but it doesn't seem to be working and I have no clue how to determine why and/or how to correct. Could you please review the attached - with your code, and help?

Thank you Bunches,

Paula

[paula.mccall]

Still Needing some help Please.

I have tried the code provided in the previous post, but it doesn't seem to be working to Clear the charts; it seems to Create the charts instead. Can someone please help me with a code that will delete or clear the charts?
I really appreciate your time and help!

Kind Regards,
Paula

[Artik]

The test_1 procedure consists of two loops. Loop For Each ... Next removes all the charts of the active sheet (if any). The second loop, For ... Next, inserts new charts into the worksheet.
Since I concluded from the first post that you are primarily interested in refreshing the charts after updating the data (changing values in already existing columns or adding/removing columns with data) I decided to combine these two loops in one procedure.

If you need two separate procedures, one for deleting charts and the other for inserting them, this set is fine:

Please Login or Register  to view this content.

Artik

[paula.mccall]

Hello Artik,

I understand your first code now; thank you for the clarification. I will use the first code, now that I understand. Thank you soooo much for your help!

Kind Regards,
Paula