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
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/
_______
"Heidi" <[email protected]> wrote in message
news:[email protected]...
>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
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(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/
> _______
>
>
> "Heidi" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks