Microsoft Excel - MS Excel Chart - what formula can I use to prevent zeros from being charted

I am trying to upload a file to show the chart and data, however, no luck with the upload.

I will keep trying.

Kathy

Hi Kathy,

People typically use NA() in a formula to prevent data points from being charted as a Zero.


There are many tutorials on the web like this one:
http://www.exceldashboardtemplates.com/how-to-hide-a-pie-chart-slice-or-stacked-column-chart-section/

So your formula might look something like this:

=if(b2>=90,90,na())

Steve=True
http://www.exceldashboardtemplates.com

Hi Kathy,
Are these real zeroes or are they missing data. 
If they are real, why don't you want them plotted?
If they are missing data (empty cells) then you can select the chart and go to Options, Chart and specify how you want them handled.
Regards
Harry