+ Reply to Thread
Results 1 to 3 of 3

How to get a Trendline to Ignore Blanks in Data

  1. #1
    Registered User
    Join Date
    06-25-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    58

    How to get a Trendline to Ignore Blanks in Data

    I've viewed a few threads on this, didn't find an elegant solution. Does anyone have one? I've attached an example that I'll explain.

    I need to break my data sets up by 8 week periods. I need trend lines for each period. The second period starts in the next 8 weeks. I can get the data to only show for the second set of 8 weeks, but the trendline wants to start from the beginning. How do I make the trend line cover the same period as the second 8 weeks?
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,769

    Re: How to get a Trendline to Ignore Blanks in Data

    Use XY-scatter series rather than Line and set data to know X and Y values
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-25-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: How to get a Trendline to Ignore Blanks in Data

    Andy, that is perfect, thank you.

    Funny, I actually ended up on your site yesterday when doing a Google search about this topic.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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