Andy, while I managed to get the display I wanted, attempting to change the label format keeps crashing Excel.
I have attached my file for you to review, if you wish to.
For example, I tried changed my label to 0;;; to hide 0 values. Just that made it crash.
I was able to do it in Excel 2010, save the file, and reopen in Excel 2007 and it works.
Please let me know if you are able to reproduce with your version of Excel 2007.
Bookmarks