Scatter Graph with Trendline and Trend band!

**ssrirao** · 05-22-2007, 05:46 AM

I have created a scatter graph in excel.
I have also added a trendline in the graph.

Now that I have to show a trend band along the trend line
with width trend line + 1 and trend line - 1.
Is it possible to do it in Excel.

Note: Please refer the file graph.zip containing the graph

**sweep** · 05-22-2007, 05:52 AM

Hi,

You could do this by taking the equation of the trendline, and modifying it to obtain two more data series.

**ssrirao** · 05-22-2007, 05:57 AM

Can anybody please explain this with an example !

Thanks

**sweep** · 05-22-2007, 06:09 AM

Can you post your data?

Dave

**ssrirao** · 05-22-2007, 08:27 AM

Consider any data,
Create a scatter graph,
add a trendline
The band should be parallel to the trendline and appear as shown in the image file attached

**sweep** · 05-22-2007, 08:37 AM

Please see attached

Dave

**ssrirao** · 05-22-2007, 09:08 AM

Thanks, This seems to be like what I want.
And one more problem.
Can v fill the area between (Trendline equation +1) and (Trendline equation -1) as in graph.zip