Line Graph Excluding 0 Values

[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.

 

[Jarek Kujawa]

one way might be to hide columns for 3 Dec, 4 Dec etc.

 

[Stefi]

Replace zeros by =NA() in source data!

Regards,
Stefi

„Sasikiran†ezt írta:

 

[Sasikiran]

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.

 

[Stefi]

Try replacing yourformula by this:

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

Regards,
Stefi

„Sasikiran†ezt írta:

 

[Sasikiran]

Thank you so much stefi... Its working

Try replacing yourformula by this:

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

Regards,
Stefi

„Sasikiran†ezt írta:

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„Sasikiran†ezt írta: