Remember Me?

#1
March 12th 06, 07:29 AM posted to microsoft.public.excel.charting
 RWB7s Posts: n/a
How do I floodfill excel scatter charts only below the trendline?

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.

#2
March 12th 06, 02:27 PM posted to microsoft.public.excel.charting
 Andy Pope Posts: n/a
How do I floodfill excel scatter charts only below the trendline?

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
#3
March 12th 06, 05:31 PM posted to microsoft.public.excel.charting
 Jon Peltier Posts: n/a
How do I floodfill excel scatter charts only below the trendline?

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Siggsy007 Charts and Charting in Excel 2 February 13th 06 11:29 AM MEGTOM New Users to Excel 5 October 27th 05 03:06 AM Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM Ched76 Charts and Charting in Excel 1 June 8th 05 03:12 AM Mattias Charts and Charting in Excel 1 December 7th 04 01:21 PM

All times are GMT +1. The time now is 05:12 AM.