Adjusting series

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

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
 
This isn't really dynamic, but you can filter the data on column C. Select
the data (including the header row: make sure you have a header row), go to
Data Menu > Filter >AutoFilter. Right click the little down arrow icon on
column C, choose (Custom), in the dialog's left hand dropdown choose Does
Not Equal, and in the right hand box type zero. The rows containing zero are
hidden, and the chart doesn't display those points, because by default a
chart shows data only from visible cells.

- Jon
 
Thank you Jon
I adapted your idea and incorporated the filter into a macro to automate the
process - works great
Sandy
 
Back
Top