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
Bookmarks