Results 1 to 2 of 2

Zero values in scatter or line chart

This is a discussion on Zero values in scatter or line chart within the Excel Questions forums, part of the Question Forums category; I searched the forum and didn't find anything helpful so I thought I would ask the question. I have a ...

  1. #1
    New Member
    Join Date
    Mar 2011
    Posts
    35

    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,365

    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

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