Graphs help
 

Hi,

I noticed that when there are cells with NA, it shows on the graph as 0. Is there a way to fix this instead?

Graphs help
 

Just right click on that cell which has a value NA and click Clear Contents.
The chart will not display zero value.

Challa Prabhu

"Aloysicus" wrote:


Hi,

I noticed that when there are cells with NA, it shows on the graph as
0. Is there a way to fix this instead?




--
Aloysicus

Graphs help
 

Don't put in NA as a text string, use #N/A or =NA() instead.
--
David Biddulph

"Aloysicus" wrote in message
...

Hi,

I noticed that when there are cells with NA, it shows on the graph as
0. Is there a way to fix this instead?