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

I'm assuming that your values for Column B is your Y-axis. And that you're
not wanting to see your graph plummet to 0 and stay there for the remainder
of the values on the X-axis.

If so, I would suggest you altering your formula that gives you the value in
Column B to show an empty cell instead of the 0. You can do that by making
the formula result be "".

If you post a copy of your formula, I would be more than happy to assist you
with modifying it to do that.

"beto" wrote:

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

The problem is that those values are coming from another workbook....
These are the values for Y axis (column B)

=AustinQ.!U17
=AustinQ.!U18
and so on.......

and what I have in the AustinQ. workbook is as follows:

=AVERAGE(E17,I17,M17,Q17)
=AVERAGE(E18,I18,M18,Q18)
and so on..........




--
asdf


"Kurt Barr" wrote:

I'm assuming that your values for Column B is your Y-axis. And that you're
not wanting to see your graph plummet to 0 and stay there for the remainder
of the values on the X-axis.

If so, I would suggest you altering your formula that gives you the value in
Column B to show an empty cell instead of the 0. You can do that by making
the formula result be "".

If you post a copy of your formula, I would be more than happy to assist you
with modifying it to do that.

"beto" wrote:

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

So if you don't want the cells with zero values to be displayed, change
=AVERAGE(E17,I17,M17,Q17)
to
=IF(AVERAGE(E17,I17,M17,Q17)=0,NA(),AVERAGE(E17,I1 7,M17,Q17))

Note that I recommend using NA() rather than an empty string "" as
recommended by Kurt, as I think you'd find that "" is plotted as a zero.
--
David Biddulph

beto wrote:
The problem is that those values are coming from another workbook....
These are the values for Y axis (column B)

=AustinQ.!U17
=AustinQ.!U18
and so on.......

and what I have in the AustinQ. workbook is as follows:

=AVERAGE(E17,I17,M17,Q17)
=AVERAGE(E18,I18,M18,Q18)
and so on..........



"Kurt Barr" wrote:

I'm assuming that your values for Column B is your Y-axis. And that
you're not wanting to see your graph plummet to 0 and stay there for
the remainder of the values on the X-axis.

If so, I would suggest you altering your formula that gives you the
value in Column B to show an empty cell instead of the 0. You can do
that by making the formula result be "".

If you post a copy of your formula, I would be more than happy to
assist you with modifying it to do that.

"beto" wrote:

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