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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Create a chart from a table in word thats dynamic 0
Mail Merge Help 1
Descenders clipped 0
Style Gallery View 3
Creating a Chart on form from selected data in query. 0
Scroll does not show preview 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0

Top