Showing "NC" in data table
 

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?

Showing "NC" in data table
 

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

AudPod wrote:
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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info