Zero values in scatter or line chart

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Zero values in scatter or line chart

  1. #1
    New Member
    Join Date
    Mar 2011
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Zero values in scatter or line chart

     
    I searched the forum and didn't find anything helpful so I thought I would ask the question.

    I have a large series of data with formulas that yield a zero value. I want to graph the data with a scatter and/or line graph but ignore the zero values and essentially interpolate between the value before and after the zero value.

    How do I do this?

    Thanks in advance.

  2. #2
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,400
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Zero values in scatter or line chart

      
    Change the formulas so that instead of zero or text (which is plotted as zero, and "" is text not a blank), they return NA() or #N/A. A line or XY plot will not draw a marker for #N/A, and will interpolate any connecting line between the points on either side.

    For more info, read Mind the Gap - Charting Empty Cells.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com