Line Graph Excluding 0 Values

  • Thread starter Thread starter Sasikiran
  • Start date Start date
S

Sasikiran

Dear,

I have plotted a line graph consisting the data for the entire month. The
data range is getting calculated automatically by a formula.

1 Dec - 100
2 Dec - 105
3 Dec - 0
4 Dec - 0
So on...

The data for the days starting from 3 Dec is zero and the line graph
suddenly goes down to zero...

Is there any way that the line graph picks the data excluding the zero
values? I mean the line graph should only take the data for 1 Dec and 2 Dec
without changing the data range.

Thank you.
 
Replace zeros by =NA() in source data!

Regards,
Stefi

„Sasikiran†ezt írta:
 
Dear Stefi,

The 0 is a result of a formula. If I replace the formula with =NA(), the
data is not reflecting in the line graph.

Is there any way to keep the formula as it it or tweak the formula such that
it results empty cell and the zero value is not reflected in the graph?

Please suggest.
 
Try replacing yourformula by this:

=IF(yourformula=0,NA(),yourformula)

Regards,
Stefi

„Sasikiran†ezt írta:
 
Thank you so much stefi... Its working :)

Stefi said:
Try replacing yourformula by this:

=IF(yourformula=0,NA(),yourformula)

Regards,
Stefi

„Sasikiran†ezt írta:
Click to expand...
 
Back
Top