If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|