Loop thru Charts in Workbook and Changing Chart 2/Error Handling

I've gotten further along as I continue to try to make this work.

Now I need to handle errors, but I'm not sure what types of errors I might come across.
It's possible a chart might be missing a data label to work with. What is best error handling method?

Looping code:

Please Login or Register  to view this content.

Hi ker9,

Good progress.

Some of the problems include:
a. Data Series missing
b. Data point missing
c. Data label missing (if point is missing)
d. Data label text is not a number (improbable but possible)

Start deleting things one at a time until you get a runtime error. Then when you find which runtime errors you get you can process or ignore the possible errors.

For example you could use something like this as a starting point.

Please Login or Register  to view this content.

Lewis