Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 not showing "previous data" | Links and Linking in Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Pivot Table showing number "1" instead of actual result | Excel Discussion (Misc queries) | |||
how do I stop showing "blanks" in a pivot table? | Excel Discussion (Misc queries) | |||
Showing top ten and then "others" in a pivot table | Excel Discussion (Misc queries) |