Graphing only data that meets a condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
In an adjacent column, write this formula:

=IF(C3>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
http://PeltierTech.com/
_______
 
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 :)
 
Back
Top