|
| 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
March 26th, 2009, 02:24 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
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
March 26th, 2009, 02:37 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
March 26th, 2009, 02:40 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 | |
|
|
Linear Mode
