Suppressing categories with 0 values

Hi all,

I'm trying to build a dynamic chart for sales data. The output file contains two columns, A and B. Column A contains categories, i.e. Apples, Oranges, Pears, etc.,. and B contains sales data, i.e. 5, 0, 10, etc.,. respectively. The ouput data comes out monthly. Some months will contain sales from all categories, some ten, some fifty. I want the chart to only graph categories with non-zero values, i.e. if there are 100 categories and only 30 with sales numbers there is no point in showing the other 70 categories with zero values. I can format column B with zero values to show #N/A or "", but either way the categories are shown on the graph. I only know the autofilter feature to suppress "" (blank) cells so the chart doesn't show it, but this is cumbersome as the chart has to be update manually each time. Any thoughts?

Thanks,

VT

Hi
have a look at
http://andypope.info/charts/piezeros.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Confusious wrote:
Hi all,

I'm trying to build a dynamic chart for sales data. The output file
contains two columns, A and B. Column A contains categories, i.e.
Apples, Oranges, Pears, etc.,. and B contains sales data, i.e. 5, 0,
10, etc.,. respectively. The ouput data comes out monthly. Some
months will contain sales from all categories, some ten, some fifty.
I want the chart to only graph categories with non-zero values, i.e.
if there are 100 categories and only 30 with sales numbers there is
no point in showing the other 70 categories with zero values. I can
format column B with zero values to show #N/A or "", but either way
the categories are shown on the graph. I only know the autofilter
feature to suppress "" (blank) cells so the chart doesn't show it,
but this is cumbersome as the chart has to be update manually each
time. Any thoughts?

Thanks,

VT