Showing "NC" in data table

A

AudPod

I have a bar chart with the data table displayed below. Some of the values
should be showing the text label of "NC" (not computed), but, the table
displays zeros. Can this be resolved?
 
A

Andy Pope

Hi,

You need to apply a custom number format to the values in the worksheet.
General;-General;"NC"

The NC will then be displayed in the data labels and or data table.

Cheers
Andy
 
Top