Results 1 to 4 of 4

Thread: How to ignore 0 value figure in line chart?

  1. #1

    How to ignore 0 value figure in line chart?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    How to ignore 0 value figure in line chart?

    I am plotting line chart.
    x-axis is month from Jan 2013 to Dec 2013.
    y-axis is revenue $.

    There is no value in the future months, but the line chart connect the line.
    In stead of selecting the data range each month, can I do some setting to ignore the zero value data?

  2. #2
    Acolyte Andy Pope's Avatar
    Join Date
    Mar 2011
    Location
    London, England
    Posts
    38
    Articles
    0
    Use NA() instead of "" in your formula.
    Cheers
    Andy

    www.andypope.info

  3. #3
    Attached a sample.
    If I don't want to modified the data range every month, how can I do to have the expected result chart? (i.e. ignore the zero value in the months)
    Attached Files Attached Files

  4. #4
    Acolyte Andy Pope's Avatar
    Join Date
    Mar 2011
    Location
    London, England
    Posts
    38
    Articles
    0
    The other alternative is to use dynamic named ranges.
    http://peltiertech.com/WordPress/dynamic-charts/
    Cheers
    Andy

    www.andypope.info

Posting Permissions

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