| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
| Question about graphing four sets of data | Charts and Charting in Excel | |||
| I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
| Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Hybrid Mode
