Solved

# drawing an error band on a line chart

Posted on 2014-11-25
86 Views
Hi,

I have a line chart and I want to make two horizontal lines at +3%-0.5% and +3%+0.5%. How do I do this in excel 2013? I keep seeing the trendline option. Can I modify that.

Thanks
0
Question by:camper12
1 Comment

LVL 27

Accepted Solution

Glenn Ray earned 500 total points
ID: 40466027
Would these two horizontal lines be at 2.5% and 3.5%, respectively AND is the line plot a percentage value as well?

If so, you would just add two new series to your existing data with these values as the only series values.

This data could be in hidden columns for separated from your main data so as not to be interfering. See the example workbook.

Regards,
-Glenn
EE-Q28569677.xlsx
0

## Featured Post

### Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…