Thread: Graphs help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default 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