Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Omitting Zeros in a chart | Excel Discussion (Misc queries) | |||
Zeros Display On Chart | Excel Discussion (Misc queries) | |||
do not show zeros in pivot chart (pie chart) | Charts and Charting in Excel | |||
Zeros in clumn chart | Charts and Charting in Excel | |||
Blanks chart as zeros | Charts and Charting in Excel |