Excel 2007 - How do I ignore zero's and #DIV/0! for a graph?
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.
February 10, 2009 8:10 PM
February 22, 2009 1:07 PM