[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 103
  • Last Modified:

drawing an error band on a line chart

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
camper12
Asked:
camper12
1 Solution
 
Glenn RayExcel VBA DeveloperCommented:
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.
error lines
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now