+ Reply to Thread
Results 1 to 3 of 3

Graphing only data that meets a condition

  1. #1
    Heidi
    Guest

    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. #2
    Jon Peltier
    Guest

    Re: Graphing only data that meets a condition

    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" <Heidi@discussions.microsoft.com> wrote in message
    news:198C24B4-651E-4917-846C-6FA4931A7CA1@microsoft.com...
    >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. #3
    Heidi
    Guest

    Re: 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(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" <Heidi@discussions.microsoft.com> wrote in message
    > news:198C24B4-651E-4917-846C-6FA4931A7CA1@microsoft.com...
    > >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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1