+ Reply to Thread
Results 1 to 4 of 4

How can I make the graph omit blank cells in the data set?

  1. #1
    easy
    Guest

    How can I make the graph omit blank cells in the data set?

    Hi,

    I've been workin' on the problem below that I've written a few days ago but
    got no answers.
    It's easy to select spesific cells to another column
    for ex: cells belong to type A
    then I draw the graph but a new problem occured, there are empth cells and
    mygraph counts them
    next question: how can I omit the blank cells from my data set while
    graphing?

    Thx a lot

    Emre UNAL
    http://www.geocities.com/dusemre









    Main Problem:

    Hi,

    I have a mixed data set as exampled below,

    Type Value
    A 14
    B 0.156
    C 1.65
    A 18
    D 400
    C 1.56
    C 1.72
    ....
    ....
    ....



    Question: How can I graph these variables individually without chancin' the
    data structure?

    Note: I can not use autofilter or any other macro, this data set will be
    updated every 2hours, but can make any link to this data set freely.

    Thx for your concern


    Emre ÜNAL
    Statistician
    http://www.geocities.com/dusemre






  2. #2
    Bernard Liengme
    Guest

    Re: How can I make the graph omit blank cells in the data set?

    a) use =NA() in place of blank
    OR
    b) select chart; use Tools|Options and open Chart tab; specify how blanks
    are to be treat with the active chart
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "easy" <dusemre@yahoo.com> wrote in message
    news:uwk0anWKFHA.3652@TK2MSFTNGP10.phx.gbl...
    > Hi,
    >
    > I've been workin' on the problem below that I've written a few days ago
    > but
    > got no answers.
    > It's easy to select spesific cells to another column
    > for ex: cells belong to type A
    > then I draw the graph but a new problem occured, there are empth cells and
    > mygraph counts them
    > next question: how can I omit the blank cells from my data set while
    > graphing?
    >
    > Thx a lot
    >
    > Emre UNAL
    > http://www.geocities.com/dusemre
    >
    >
    >
    >
    >
    >
    >
    >
    >
    > Main Problem:
    >
    > Hi,
    >
    > I have a mixed data set as exampled below,
    >
    > Type Value
    > A 14
    > B 0.156
    > C 1.65
    > A 18
    > D 400
    > C 1.56
    > C 1.72
    > ...
    > ...
    > ...
    >
    >
    >
    > Question: How can I graph these variables individually without chancin'
    > the
    > data structure?
    >
    > Note: I can not use autofilter or any other macro, this data set will be
    > updated every 2hours, but can make any link to this data set freely.
    >
    > Thx for your concern
    >
    >
    > Emre ÜNAL
    > Statistician
    > http://www.geocities.com/dusemre
    >
    >
    >
    >
    >




  3. #3
    Bernard Liengme
    Guest

    REPOST: Re: How can I make the graph omit blank cells in the data set?

    a) use =NA() in place of blank
    OR
    b) select chart; use Tools|Options and open Chart tab; specify how blanks
    are to be treat with the active chart
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "easy" <dusemre@yahoo.com> wrote in message
    news:uwk0anWKFHA.3652@TK2MSFTNGP10.phx.gbl...
    > Hi,
    >
    > I've been workin' on the problem below that I've written a few days ago
    > but
    > got no answers.
    > It's easy to select spesific cells to another column
    > for ex: cells belong to type A
    > then I draw the graph but a new problem occured, there are empth cells and
    > mygraph counts them
    > next question: how can I omit the blank cells from my data set while
    > graphing?
    >
    > Thx a lot
    >
    > Emre UNAL
    > http://www.geocities.com/dusemre
    >
    >
    >
    >
    >
    >
    >
    >
    >
    > Main Problem:
    >
    > Hi,
    >
    > I have a mixed data set as exampled below,
    >
    > Type Value
    > A 14
    > B 0.156
    > C 1.65
    > A 18
    > D 400
    > C 1.56
    > C 1.72
    > ...
    > ...
    > ...
    >
    >
    >
    > Question: How can I graph these variables individually without chancin'
    > the
    > data structure?
    >
    > Note: I can not use autofilter or any other macro, this data set will be
    > updated every 2hours, but can make any link to this data set freely.
    >
    > Thx for your concern
    >
    >
    > Emre ÜNAL
    > Statistician
    > http://www.geocities.com/dusemre
    >
    >
    >
    >
    >


  4. #4
    easy
    Guest

    Re: How can I make the graph omit blank cells in the data set?

    Thx Bernard,

    I still have gaps between values, how can I omit them?
    for.ex. data set is below
    I've tried your recommendations but still got gaps for all the #N/A



    A 1 1
    B 10 #N/A
    D 100 #N/A
    C 1000 #N/A
    A 1,5 1,5
    B 15 #N/A
    C 105 #N/A
    D 1005 #N/A
    A 2 2
    B 12 #N/A
    C 102 #N/A
    D 1002 #N/A




    "Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
    news:ukpdCNZKFHA.688@TK2MSFTNGP10.phx.gbl...
    > a) use =NA() in place of blank
    > OR
    > b) select chart; use Tools|Options and open Chart tab; specify how blanks
    > are to be treat with the active chart
    > best wishes
    > --
    > Bernard V Liengme
    > www.stfx.ca/people/bliengme
    > remove caps from email
    >
    > "easy" <dusemre@yahoo.com> wrote in message
    > news:uwk0anWKFHA.3652@TK2MSFTNGP10.phx.gbl...
    > > Hi,
    > >
    > > I've been workin' on the problem below that I've written a few days ago
    > > but
    > > got no answers.
    > > It's easy to select spesific cells to another column
    > > for ex: cells belong to type A
    > > then I draw the graph but a new problem occured, there are empth cells

    and
    > > mygraph counts them
    > > next question: how can I omit the blank cells from my data set while
    > > graphing?
    > >
    > > Thx a lot
    > >
    > > Emre UNAL
    > > http://www.geocities.com/dusemre
    > >
    > >
    > >
    > >
    > >
    > >
    > >
    > >
    > >
    > > Main Problem:
    > >
    > > Hi,
    > >
    > > I have a mixed data set as exampled below,
    > >
    > > Type Value
    > > A 14
    > > B 0.156
    > > C 1.65
    > > A 18
    > > D 400
    > > C 1.56
    > > C 1.72
    > > ...
    > > ...
    > > ...
    > >
    > >
    > >
    > > Question: How can I graph these variables individually without chancin'
    > > the
    > > data structure?
    > >
    > > Note: I can not use autofilter or any other macro, this data set will be
    > > updated every 2hours, but can make any link to this data set freely.
    > >
    > > Thx for your concern
    > >
    > >
    > > Emre ÜNAL
    > > Statistician
    > > http://www.geocities.com/dusemre
    > >
    > >
    > >
    > >
    > >

    >
    >




+ 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