If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
chart lines
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. |
#2
|
|||
|
|||
chart lines
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Susie" wrote in message ... 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. |
#3
|
|||
|
|||
chart lines
Change your formula so that instead of displaying 0, it displays the #N/A
error (which charts ignore) Example: =IF(A2A3,A2-A3,NA()) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Susie" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|