Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 12th 06, 07:29 AM posted to microsoft.public.excel.charting
RWB7s
 
Posts: n/a
Default 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   Report Post  
Old March 12th 06, 02:27 PM posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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   Report Post  
Old March 12th 06, 05:31 PM posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charts - Trends - Excel Formula Siggsy007 Charts and Charting in Excel 2 February 13th 06 11:29 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
I'm loosing colour when copying charts from excel to word. Ched76 Charts and Charting in Excel 1 June 8th 05 03:12 AM
How do I get the trendline equation from Excel to script? 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.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017