If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cross program data sharing | m_jurrens | General Discussion | 1 | December 16th, 2005 05:29 PM |
Query does not order the same data in the same way | Milković Aleksandar | Running & Setting Up Queries | 10 | December 15th, 2005 12:01 PM |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |