Excel 2007 – How do I ignore zero’s and #DIV/0! for a graph?

185 pts.
Tags:
Excel 2007
Excel Charts
Microsoft Excel
Microsoft Office
Excel 2007 - How do I ignore zero's and #DIV/0! for a graph? example: you have data that looks something like this: week # 1 2 3 4 5 6 PTP% 10% 13% 0% 0% #DIV/0! 0 % Then graph the PTP% across from week 1 which is 10% to week 6 which is 0% On the graph all u will see is the plots from week 1 & 2. But then you will see the charted line drop to zero from Week #2. My ? is does anyone know the formula i could use if the cells are zero or #DIV/0! leave blank? Nesting more than 3 formulas sounds like the best way for this to work correctly. Any ideas would be great thanks. Jared~

Answer Wiki

Thanks. We'll let you know when a new response is added.

I am not pretty clear about your query. However, you want to have blank in cell instead of Div/0 error.

You can use the formula mentioned below
suppose A1 has numerator values and B1 has denominator value which does not exist or is zero. So you have Div/0 error in C1 which has formula A1/B1

=IF(ISERROR(A1/B1), “”, A1/B1)

The formula will return blank is there is any error while dividing.

If this resolve your issue. Do let me know

Regards,
Sarfaraz Ahmed

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following