Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts - Trends - Excel Formula | Charts and Charting in Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
I'm loosing colour when copying charts from excel to word. | Charts and Charting in Excel | |||
How do I get the trendline equation from Excel to script? | Charts and Charting in Excel |