I have a simple chart (column) based on the following:

B5 = Top C5 = 0
B6 = Left C6 = 5
B7 = Right C7 = 8
B8 = Bottom C8 = 0

The x-axis has 'Top', 'Left', 'Right' and 'Bottom' and the Y-axis the
values.

What I would like to do is have the chart only show the elements that are
not zero (they will never be negative). So in the above case the chart would
only show 'Left' and 'Right' - however should 'Top' or 'Bottom' or both
become 0 then they should be incorporated. Conversely should 'Left' or
'Right' or any other value become 0 then they would drop out.

Am I making sense?
Any ideas?
Sandy