Adjust formatting code for data labels to be blank when there is no values

Hi All,

I would like for my data labels to auto adjust if there are no values. Currently this format code

Please Login or Register  to view this content.

will display $- when there are no values.

Try it with this format string:

_($* #,##0.00_);_($* (#,##0.00);;_(@_)

The third term describes how zero values should be displayed, so in this case they will show as blank.

Hope this helps.

Pete