How do I set up a chart to only chart values greater than 0

  • Thread starter Thread starter debra49424
  • Start date Start date
D

debra49424

I have a chart in Excell that I would like to only have chart those items
with a value of greater than 0 (zero). Not sure if there is a better, easier
way than having manually manipulate the data.
 
Let's say the values are in B1:B20
In C1 enter =IF(B1>0,B1,NA())
Now use column C for the chart; the displayed #N/A values will be ignored by
the chart engine
best wishes
 
This topic wasn't the reason I was looking through this discussion board but
I can definitely use the information!
Thank you.
 
Back
Top