ExcelBanter - Omitting 0% from column charts

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Omitting 0% from column charts (https://www.excelbanter.com/excel-discussion-misc-queries/267270-omitting-0%25-column-charts.html)

Stepper

Omitting 0% from column charts

I am trying to omit #N/A errors showing as 0 or 0% on column charts, but I still want the actual 0 and 0% values to show.

Can this be done?

All times are GMT +1. The time now is 04:55 AM.