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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Sandy" wrote in message
...
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

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

"Jon Peltier" wrote in message
...
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Sandy" wrote in message
...
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

The link below requires more work - but it provides a dynamic option.

http://www.cellmatrix.net/index.php/...de_zero_values

--
John Mansfield
http://cellmatrix.net





"Sandy" wrote:

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

"Jon Peltier" wrote in message
...
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Sandy" wrote in message
...
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