Use the trendline coefficients to generate points in the worksheet, and use
this technique to produce a combination Area-XY chart:
http://peltiertech.com/Excel/Charts/...ertErrBar.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
"RWB7s" wrote in message
...
Any idea how I can floodfill an Excel scatter chart, but only below the
trendline? I can easily flood fill the entire body of the chart, but I
need
to fill only below or above the trendline, or a selected area of the
chart.
Help! Thanks.