#N/A with Graph Labels (X2K)

Topic

New Reply

I have set up some bar chart graphs with their Data Labels set to Show Value,

In the data for the graph I have used an if statement to show the data to use or the na() function if no data available to show.

The problem that I am having is that the Data Label shows the #N/A as the value. If I change the na() function in the formula to a blank – “” then the Data Label shows a 0.

How can I persuade the graph to just leave an unfilled gap when there is no data

Peter

Reply | Quote

Replies

Peter

Instead of a blank – “” try a space – ” ”

Wassim in the

Reply | Quote

Space gives a 0.

Odd thing with the na() is that the lable (showing #N/A )wanders around the graph! it seems to get lost with no column to attach itself to.

Reply | Quote

Hi Peter,
You can format the data labels and give them a custom number format like
0.00;-0.00;
and they should then display nothing rather than 0 for your missing values (assuming you use “” rather than na() in your formulae).
Hope that helps.

Reply | Quote

Many Thanks, Just what I needed

Peter

Reply | Quote