In an adjacent column, write this formula:

=IF(C31,C3,NA())

where C3 is that row's piece of data. Now make your chart from this added
column.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Heidi" wrote in message
...
I have a set of data (one record per row) that is added to daily. I would
like to graph only data where the value in a column meets a certain
condition
(1.0).

Is this possible? If so, how?

Thank you!

Heidi