software

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
(gt;1.0).

Is this possible? If so, how?

Thank you!

Heidi

In an adjacent column, write this formula:

=IF(C3gt;1,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
PeltierTech.com/
_______quot;Heidiquot; gt; wrote in message
...
gt;I have a set of data (one record per row) that is added to daily. I would
gt; like to graph only data where the value in a column meets a certain
gt; condition
gt; (gt;1.0).
gt;
gt; Is this possible? If so, how?
gt;
gt; Thank you!
gt;
gt; Heidi
That is so simple! I'm slapping my head for not thinking of that myself.
Thank you so much!

BTW - LOVE LOVE LOVE your website

quot;Jon Peltierquot; wrote:

gt; In an adjacent column, write this formula:
gt;
gt; =IF(C3gt;1,C3,NA())
gt;
gt; where C3 is that row's piece of data. Now make your chart from this added
gt; column.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt;
gt; quot;Heidiquot; gt; wrote in message
gt; ...
gt; gt;I have a set of data (one record per row) that is added to daily. I would
gt; gt; like to graph only data where the value in a column meets a certain
gt; gt; condition
gt; gt; (gt;1.0).
gt; gt;
gt; gt; Is this possible? If so, how?
gt; gt;
gt; gt; Thank you!
gt; gt;
gt; gt; Heidi
gt;
gt;
gt;