Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Caerus
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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
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
missing data points causes my line graph not to connect liebw Charts and Charting in Excel 8 November 24th 08 10:15 PM
How can I suppress a portion of a line graph? rshalayda Charts and Charting in Excel 1 September 21st 05 07:22 PM
Possible to Add Horizontal Line to Embedded Graph via VBA? TimSchwaar Charts and Charting in Excel 5 August 29th 05 11:41 PM
Using a formula to create named range reference [email protected] Excel Worksheet Functions 4 June 29th 05 08:03 PM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM


All times are GMT +1. The time now is 06:06 PM.

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

About Us

"It's about Microsoft Excel"