| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
