Charts will not automatically exclude zero data points.

You have to either use auto filter to hide rows not required in chart, making sure chart has option to display visible cells only.

Or create dedicated chart data that excludes the zero items.

__________________
Cheers
Andy
www.andypope.info