Hi,
I've a set of values that creates a line graph, most values are around the 90% mark, but there are a few zeros.
Rather the the line graph dropping from 90% to 0%, I'd rather not show the line to zero.
Tried everything (well everything i thought of), the only way it work is when i actually delete the formula, leaving a genuine blank cell. But this is practical, as I need the formula.
Thanks in advance for any help...
Paul
I've a set of values that creates a line graph, most values are around the 90% mark, but there are a few zeros.
Rather the the line graph dropping from 90% to 0%, I'd rather not show the line to zero.
Tried everything (well everything i thought of), the only way it work is when i actually delete the formula, leaving a genuine blank cell. But this is practical, as I need the formula.
Thanks in advance for any help...
Paul