Ignoring Values of Zero in a Pie Chart

[cpalmer72]

Is it possible to create a dynamic pie chart that will ignore a zero amount in the source data? Our chart is to show a breakdown of monthly sales by department and sometimes a given department may have sales in a month and sometimes it may not. We would like the chart to ignore any $0 amount instead of putting a tiny slice in the pie chart with a $- next to it.

Thanks!

[martindwilson]

create another series using Na() instead of 0 simply like if(b2=0,na(),b2) and use that see attached

[cpalmer72]

Exactly what I needed! Thanks!