Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to eliminate zero values on graphs when formula calculates 0?
I'm setting up a graph of data that is calculated with an "if" function over
a series of days of input data including future days. When the input data cell is blank I would like the calculated value to not show a zero value on the graph. If the cell were blank, the plot would not show a zero value. The problem is that at the end of the line graph the line always falls off to zero. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to eliminate zero values on graphs when formula calculates 0?
=IF(A1="",NA(),your_formula)
-- David Biddulph "sjgolfer" wrote in message ... I'm setting up a graph of data that is calculated with an "if" function over a series of days of input data including future days. When the input data cell is blank I would like the calculated value to not show a zero value on the graph. If the cell were blank, the plot would not show a zero value. The problem is that at the end of the line graph the line always falls off to zero. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to eliminate zero values on graphs when formula calculates
Thanks David. That does make the cell blank but unfortunately it still plots
as a zero on the graph. SJgolfer "David Biddulph" wrote: =IF(A1="",NA(),your_formula) -- David Biddulph "sjgolfer" wrote in message ... I'm setting up a graph of data that is calculated with an "if" function over a series of days of input data including future days. When the input data cell is blank I would like the calculated value to not show a zero value on the graph. If the cell were blank, the plot would not show a zero value. The problem is that at the end of the line graph the line always falls off to zero. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to eliminate zero values on graphs when formula calculates
A value of #N/A (coming from the NA() function) is ignored by the chart
engine Want to send me a sample file to check? Get me email from my website best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "sjgolfer" wrote in message ... Thanks David. That does make the cell blank but unfortunately it still plots as a zero on the graph. SJgolfer "David Biddulph" wrote: =IF(A1="",NA(),your_formula) -- David Biddulph "sjgolfer" wrote in message ... I'm setting up a graph of data that is calculated with an "if" function over a series of days of input data including future days. When the input data cell is blank I would like the calculated value to not show a zero value on the graph. If the cell were blank, the plot would not show a zero value. The problem is that at the end of the line graph the line always falls off to zero. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to eliminate zero values on graphs when formula calculates
Problem solved. The cell were no empty but contained zeros and the
worksheet was formatted not to show zeros! -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "sjgolfer" wrote in message ... Thanks David. That does make the cell blank but unfortunately it still plots as a zero on the graph. SJgolfer "David Biddulph" wrote: =IF(A1="",NA(),your_formula) -- David Biddulph "sjgolfer" wrote in message ... I'm setting up a graph of data that is calculated with an "if" function over a series of days of input data including future days. When the input data cell is blank I would like the calculated value to not show a zero value on the graph. If the cell were blank, the plot would not show a zero value. The problem is that at the end of the line graph the line always falls off to zero. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Eliminate duplicate values in drop down list | Excel Discussion (Misc queries) | |||
formula only calculates when clicked | Excel Worksheet Functions | |||
How do I eliminate negative values in a spreadsheet ? | Excel Discussion (Misc queries) | |||
How do I eliminate duplicate values in a series of data in excel? | Excel Discussion (Misc queries) | |||
formula that calculates upon saving only | Excel Discussion (Misc queries) |