chart lines

  • Thread starter Thread starter Susie
  • Start date Start date
S

Susie

how do I prevent a chart line from connecting to a 0%? The 0% value results
from data that has not been entered yet, but shows due to the % formula.
 
In a Line or XY chart, replace the blank by =NA()
The chart engine will ignore this
It will display as #N/A
If you don't like the look of this (maybe for printing purposes) use
conditional formatting to make the font colour the same as the cell
background, then it 'disappears'
best wishes
 
Change your formula so that instead of displaying 0, it displays the #N/A
error (which charts ignore)
Example:
=IF(A2>A3,A2-A3,NA())
 
Back
Top