non linear shading
I would like to put a shade area between my data sets, I plotted them using scattered plot and add polynomial trend line. These trend lines do not
cross, I need to draw a shade area between the polynomial line with max height and line with min height to show variation of my data sets.
I appreciate your help.
Pom
To do the shading you need to use 2 additional series plotted as stacked area.
The first area will match the lower trendline. The second will be the distance between the trendlines.
The tough part is generating a set of data for the area series based on your trendline formula.
Using Linest will give you the components of the equation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks