How to apply custom number format to all data labels across many bar charts

Dear VBA experts,

I'm writing to request your help with my excel chart bar issues. I itinially had posted it here,
http://https://www.excelforum.com/excel-charting-and-pivots/1298414-how-to-remove-0-0s-from-excel-bar-chart-displays.html#post5239481

Two of the excel experts recommended that I apply a custom number format to all the data labels, like this: 0.0;-0.0;; to make sure that the bar charts do not display 0.0 when they are not supposed to be displayed, which was very helpful.

My problem is, I have many more charts like this that occur within a single worksheet, across worksheets and workbooks, and I wonder if there's a way to apply some kind of vba programming so that it could do this at once, rather than for me to go into each data label, change each custom number format, go to the next bar chart, and do this like hundreds of times. Not only this is time consuming but error prone as well (I just know that I will miss some of the data labels if I have to go through so many!)

Would someone be able to help me with the vba code for this? I don't know anything about the vba and would not be able to do this on my own.

I'm reattaching the same data sheet I had attached in the earlier post for your convenience.


Thank you for your attention on this.

Sincerely,

Anita

Good morning, Rory,

Why, this is amazing!!! I tested these and they worked. I don't understand most of it, but one step at a time. Thank you so much for your VBA expertise because it will save me tons of hours from painstakingly going through each data label and changing one by one.

And I now saw your question from my other thread . Sorry about that. I think I panicked for not figuring out a solution right away so I spent a bunch of time on the internet searching for a solution and missed your question.

Have a wonderful day,

Anita