+ Reply to Thread
Results 1 to 6 of 6
  1. #1
    Alison
    Guest

    Ignoring 0 values in the series data

    How can I get my chart to ignore values which are zero in the series data and
    not show these?

  2. #2
    Forum Guru
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    replace zeros with =NA()

    Mangesh

  3. #3
    Jerry W. Lewis
    Guest

    Re: Ignoring 0 values in the series data

    You can delete the formulas that are producing zero, or replace them with
    =IF(formula=0,#N/A,formula)

    Jerry

    Alison wrote:

    > How can I get my chart to ignore values which are zero in the series data and
    > not show these?



  4. #4
    Alison
    Guest

    RE: Ignoring 0 values in the series data

    What you have told me works but I would also like the chart to ignore the
    chart label that the zero relates to. I have a spreadsheet that shows how
    much time has been spent on differnet customer sites. Using data validation
    and a look up table I have set it up so that you can select a partner and
    view which customers it has worked on. The problem is the x axis shows all
    the customers for FY05, meaning the graph is quite large with lots of empty
    spaces. When you select the partner you want to view I would like the graph
    to ignore all the customers with 0 and only show the actve ones. Is this
    possible?!

    "Alison" wrote:

    > How can I get my chart to ignore values which are zero in the series data and
    > not show these?


  5. #5
    Jerry W. Lewis
    Guest

    Re: Ignoring 0 values in the series data

    I think you will have to set up cells that summarize only the customers
    worked on, and plot that summary information.

    Jerry

    Alison wrote:

    > What you have told me works but I would also like the chart to ignore the
    > chart label that the zero relates to. I have a spreadsheet that shows how
    > much time has been spent on differnet customer sites. Using data validation
    > and a look up table I have set it up so that you can select a partner and
    > view which customers it has worked on. The problem is the x axis shows all
    > the customers for FY05, meaning the graph is quite large with lots of empty
    > spaces. When you select the partner you want to view I would like the graph
    > to ignore all the customers with 0 and only show the actve ones. Is this
    > possible?!
    >
    > "Alison" wrote:
    >
    >
    >>How can I get my chart to ignore values which are zero in the series data and
    >>not show these?



  6. #6
    Mike Punko
    Guest

    Re: Ignoring 0 values in the series data

    here yah go

    http://www.andypope.info/charts/brokenlines.htm

    "Jerry W. Lewis" wrote:

    > I think you will have to set up cells that summarize only the customers
    > worked on, and plot that summary information.
    >
    > Jerry
    >
    > Alison wrote:
    >
    > > What you have told me works but I would also like the chart to ignore the
    > > chart label that the zero relates to. I have a spreadsheet that shows how
    > > much time has been spent on differnet customer sites. Using data validation
    > > and a look up table I have set it up so that you can select a partner and
    > > view which customers it has worked on. The problem is the x axis shows all
    > > the customers for FY05, meaning the graph is quite large with lots of empty
    > > spaces. When you select the partner you want to view I would like the graph
    > > to ignore all the customers with 0 and only show the actve ones. Is this
    > > possible?!
    > >
    > > "Alison" wrote:
    > >
    > >
    > >>How can I get my chart to ignore values which are zero in the series data and
    > >>not show these?

    >
    >


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.2.0