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 |
Chart and Zeros
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 |
Chart and Zeros
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 |
Chart and Zeros
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 |
All times are GMT +1. The time now is 10:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com