Thread: Chart and Zeros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Beto Beto is offline
external usenet poster
 
Posts: 24
Default Chart and Zeros

This is the issue:
Let say I have :

ColumnA ColumnB
1 234
2 432
3 -8
4 0...
5 0...
... ..0..
... ..0..
300 0...

I'm doing a linear graph and I want as "x-value" Column A, and "y-value"
Column B. But I do not want the zeros to appear in the graph.
week by week the zeros will change as days pass until reach 300.
automatically.

Is there any way to set the graph up to take just number greater and lesser
than zeros?


--
asdf