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
|
|||
|
|||
Do not show a portion of the data series if the value is 0
Say I have data as follows
Apr-09 May-09 Jun-09 1.00 2.00 2.00 0.00 1.00 1.00 0.00 0.00 2.00 If the quantities I have listed are driven off of formulas, how could I not plot the zero values. Thanks |
#2
|
|||
|
|||
Do not show a portion of the data series if the value is 0
Would have been nice to see the formula but I will make one up
You might have =A1/10 Change it to =IF(A1=0,NA(),A1/10) When you make the chart, the cells with NA() (which display as #N/A) will not get plotted best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "asmithbcat" wrote in message ... Say I have data as follows Apr-09 May-09 Jun-09 1.00 2.00 2.00 0.00 1.00 1.00 0.00 0.00 2.00 If the quantities I have listed are driven off of formulas, how could I not plot the zero values. Thanks |
Thread Tools | |
Display Modes | |
|
|