Hi,

Here are some example of tricks to use for creating fill effects.

http://peltiertech.com/Excel/Charts/...ndex.html#Fill
http://tushar-mehta.com/excel/newsgr...ial/index.html

If the trendline is a built-in trend line then you will need create
values by using formula.
http://www.stfx.ca/people/bliengme/E...Polynomial.htm
http://tushar-mehta.com/excel/tips/t...efficients.htm

Cheers
Andy

RWB7s wrote:
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.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info