+ Reply to Thread
Results 1 to 2 of 2

Error bars for one line in multi stacked area chart

  1. #1
    Registered User
    Join Date
    07-13-2015
    Location
    Brisbane, Australia
    MS-Off Ver
    2013
    Posts
    31

    Angry Error bars for one line in multi stacked area chart

    Hi all,

    I am having trouble with the error bars on a multi-stacked chart. There are 2 sections to the chart (historical & forecast) and I only want the forecast line to show the error bars (custom from cell D35). When I use percentage it works fine but when I switch to custom it creates the error bars for both line.

    I have attached the problem chart.

    Thanks in advance Book2.xlsx

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Error bars for one line in multi stacked area chart

    Try in J43 formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    (or similar) and copy down
    and use as a source for your custom error bars not just D35 but J43:J61
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Kaper; 02-09-2016 at 10:40 AM.
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 12-09-2015, 12:41 PM
  2. [SOLVED] adding an average line to Stacked Area in 3-D chart
    By fight2 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-11-2015, 01:52 PM
  3. Replies: 2
    Last Post: 12-16-2014, 12:47 PM
  4. Replies: 5
    Last Post: 07-16-2011, 08:07 AM
  5. Stacked Area Chart problem - filling above line?
    By dannytoone in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-03-2011, 09:33 AM
  6. [SOLVED] How to create combination stacked area and line chart?
    By BarbAug in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-19-2005, 09:06 AM
  7. [SOLVED] To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1