+ Reply to Thread
Results 1 to 2 of 2

Can you shade in trend line

  1. #1
    Forum Contributor
    Join Date
    07-06-2008
    Location
    NC
    Posts
    149

    Can you shade in trend line

    My data is all over the place. When I trend it it looks better. This data is only a simulation so the trend works great, but it's only a line.....my real graph is shaded in and I like that feature but the data is too volatile, too many peaks and valleys.

    Anyway i can make the trend data have something under it (shaded area under it)????

    The data size is huge, too hard to go in an manually change the values and too big to make as an attachment unless I delete some data.

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

    Re: Can you shade in trend line

    Shading is normally achieved by using an series plotted as a area chart, although with enough points error bars can be used.

    So plot a series based on the trendline equation

    Post example workbook if you need more help
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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