|
| 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
January 19th, 2006, 06:21 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
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
January 19th, 2006, 08:01 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
January 19th, 2006, 08:32 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
Linear Mode
