Thread: Do not show a portion of the data series if the value is 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default 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



Reply With QuoteReply With Quote