Line Graph Excluding 0 Values

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

Stefi

Replace zeros by =NA() in source data!

Regards,
Stefi

„Sasikiran†ezt írta:
 
S

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

Stefi

Try replacing yourformula by this:

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

Regards,
Stefi

„Sasikiran†ezt írta:
 
S

Sasikiran

Thank you so much stefi... Its working :)

Stefi said:
Try replacing yourformula by this:

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

Regards,
Stefi

„Sasikiran†ezt írta:
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi

„Sasikiran†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top