+ Reply to Thread
Results 1 to 4 of 4

Plot across empty values without plotting to zero-value on blank cells 1,2,3,-,-,6,-,-,9,-

  1. #1
    Registered User
    Join Date
    04-06-2015
    Location
    Christchurch
    MS-Off Ver
    Exel 2007
    Posts
    2

    Plot across empty values without plotting to zero-value on blank cells 1,2,3,-,-,6,-,-,9,-

    I am plotting intermittent data (0 to 80) against a monthly axis. Some days don't have values and the plot returns to ZeroValue for that day. Is it possible to 'ignore' null days and plot from the 'previous' to the 'next' value listed? As a 'newbie' please be detailed. Thank you for your time.
    Attached Images Attached Images

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: Plot across empty values without plotting to zero-value on blank cells 1,2,3,-,-,6,-,-

    Try using =NA() in the cells that plot as zero, but which should be skipped
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    04-06-2015
    Location
    Christchurch
    MS-Off Ver
    Exel 2007
    Posts
    2

    Red face Re: Plot across empty values without plotting to zero-value on blank cells 1,2,3,-,-,6,-,-

    Thank you, Glenn Kennedy, for an ;instant; solution to the Problem!! As a Newbie, this saved me Hours of trial and error.
    Thanks to the Group also.
    I was not expecting solving the problem tonight!
    How does the Query get marked SOLVED??
    Phil Thompson.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: Plot across empty values without plotting to zero-value on blank cells 1,2,3,-,-,6,-,-

    Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Plotting Zero Values (Logarithmic Scatter Plot)
    By aaochsner in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 10-30-2013, 02:40 PM
  2. Plotting Empty Cells
    By Phil Hageman in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-13-2013, 09:02 AM
  3. Excel 2010 - X Y scatter plot will not plot empty cells as gap
    By bjeffers0306 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-12-2013, 12:56 AM
  4. blank cells plot as zero values
    By Pete Nelson in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-17-2006, 10:10 PM
  5. Can I avoid plotting 'non-empty' cells
    By germullen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-11-2006, 09:49 AM

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.6.0 RC 1