Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2010
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello Everyone,

    I did attempt to search Google and WS Lounge first, but no luck..

    I am looking to only trend data that is available.

    [attachment=90805:example.bmp]

    The example above, I do not want the trendline to start until the first data point is available.

    Thanks in advance for any assistance or direction anyone can offer.

    Enjoy your day everyone.
    Attached Images Attached Images

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 105 Times in 90 Posts
    I confess I am not sure what I am looking at in the picture you posted !

    However, Excel charts in general ignore data points where the value is #N/A (no quotes), so I'd start by entering that where you currently have absent data points and take it from there.

    This technique certainly works for instance when you want a graph to start part-way or end through a time-series.

Posting Permissions

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