G
Guest
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
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