|
Graphing only data that meets a condition
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 |
Graphing only data that meets a condition
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 |
Graphing only data that meets a condition
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 :) "Jon Peltier" wrote: 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 |
| All times are GMT +1. The time now is 06:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com