Do you mean that you don't want to see a category if there are no values for it? If so, put this formula in G2:
=SUM(B2:E2)
and copy it down to the bottom of your data. Then apply AutoFilter to column G, and in the filter drop-down unselect zero.
Your chart will now be compressed and only show the three categories that have values greater than zero. If your values change then you will need to reapply the filter, as this is not dynamic.
Hope this helps.
Pete
Bookmarks