View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
exalan exalan is offline
external usenet poster
 
Posts: 28
Default Data label with text "N/A"

Hello,

I've a simple column chart plotting % of daily on time delivery. There are
days that I don't have any delivery so I insert "N/A" to the relevant cells.
However, when I inserted data labels to the chart, those values with "N/A"
were shown as 0%.

Without hiding the rows with "N/A", what other ways can I do to have data
labels not showing "N/A" as 0%?

Many thanks in advance...


--
exalan