Results 1 to 5 of 5

Thread: How remove line dropoff in chart?

  1. #1

    How remove line dropoff in chart?



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

    In the file below. I have a average line that drops off when it moves into the following day.

    I have a formula which should default the cell to NA,But it goes to #DIV

    I just cant remove the drop
    anyone know how to solve this?
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    There are no formulae in the file you attached - what formula are you using at the moment?

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    F4 copied down:
    =IFERROR(AVERAGEIF(C4:E4,">0"),NA())
    ?

  4. #4

    chart drop off

    Quote Originally Posted by p45cal View Post
    F4 copied down:
    =IFERROR(AVERAGEIF(C4:E4,">0"),NA())
    ?

    Yes , sorry here is the file. NA is showing , can't figure out how to remove drop in chart.
    Attached Files Attached Files

  5. #5
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    Still no formulae in the file and, by the way #DIV/0! is showing (not NA) but it's just text in a cell.
    What formula are you using yourself?
    Did you try my formula?
    Do you have macros in your actual file?
    What version of Excel are you using?

    I can get rid of the 'drop-off' but I need to know we're on the same page.

    If you can get NA to show in that cell as a result of a formula, all you may need to do is change the chart type of that yellow series from
    Stacked line with markers
    to
    Line with markers.
    Last edited by p45cal; 2015-09-30 at 06:04 PM.

Posting Permissions

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