ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do you create a colored probability range around a graph line (https://www.excelbanter.com/charts-charting-excel/61263-how-do-you-create-colored-probability-range-around-graph-line.html)

Caerus

How do you create a colored probability range around a graph line
 
I am looking to add a probability range around an established line in an
excel chart. Ideally I would like to link the error bars and create a
colored area.

Andy Pope

How do you create a colored probability range around a graphline
 
Hi,

You can adapt Jon Peltier's explanation of shading between lines to
shade an area around the line.
http://pubs.logicalexpressions.com/P...cle.asp?ID=590

Cheers
Andy

Caerus wrote:
I am looking to add a probability range around an established line in an
excel chart. Ideally I would like to link the error bars and create a
colored area.


--

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


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com