+ Reply to Thread
Results 1 to 2 of 2

Most of the high-low error bars do not appear

  1. #1
    Registered User
    Join Date
    07-12-2017
    Location
    Australia
    MS-Off Ver
    Pro Plus 10
    Posts
    9

    Most of the high-low error bars do not appear

    Hi,
    I used the excellent help by Andy Pope here: excelforum.com/excel-charting-and-pivots/1009274-high-low-chart-with-multiple-series-per-day.html and it seems to do what I need. However, I've had to expand the data series and now I can get the mean to appear but the new high-low error bars don't show up, only the first in the series. I can't for the life of me figure out what I've done wrong. I've been into every chart setting I can find and all seems to be in order but clearly it is not! Any advice please?
    Attached Files Attached Files
    Last edited by Mr fish; 12-01-2020 at 09:55 PM.

  2. #2
    Registered User
    Join Date
    07-12-2017
    Location
    Australia
    MS-Off Ver
    Pro Plus 10
    Posts
    9

    Re: Most of the high-low error bars do not appear

    Solved - I needed to go into the format error bars and adjust the range of cells under 'Custom' - so simple, but easily overlooked.

+ 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. Error of slope from lineat fit with y-error bars
    By mimblewimble in forum Excel General
    Replies: 2
    Last Post: 09-03-2019, 02:05 PM
  2. Replies: 4
    Last Post: 07-14-2013, 12:19 AM
  3. Replies: 2
    Last Post: 03-28-2012, 02:29 PM
  4. Range bars, not error bars
    By Anselm in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-14-2010, 12:38 AM
  5. chart: error bars with custom error range
    By brickc1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-26-2009, 11:52 AM
  6. [SOLVED] XY Scatter Charts, High/Low bars, Multiple Series
    By Kevin M. in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-01-2006, 05:20 PM
  7. High bars
    By AhmtDY in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-25-2005, 06:05 AM

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