+ Reply to Thread
Results 1 to 2 of 2

Custom error bars not showing

  1. #1
    Registered User
    Join Date
    08-04-2011
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Custom error bars not showing

    Hi,

    I am having a issue with custom error bars. I am use to using this function in excel and have followed the usual route. However, on this occasion when I attempt to add my custom standard error values to the chart nothing happens, no error bars are added. All the pre-set error bars such as % and SD seem to work fine, there is only this problem when I attempt to add my custom error bars.

    The plot however thickens further, on some of the charts I can add three out of the four custom values, as you will see if you attempt this however the fourth value does not appear. On the first chart I get nothing each time I attempt to add my error bars.

    I have tried several different things out and still nothing works. The error bar values are below the charts, the black line requires the top values reading left to right and the gray line requires the bottom set of values.

    Any help here would be amazing as I have a few of these data sets and they all seem to have the same problem. I use 2007 version.

    Many Thanks,

    Tom
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: Custom error bars not showing

    This may have something to do with the data for the series but it's hard to tell as they reference a workbook on your local system.

    The series formula appears to suggest the line series should have 4 data points but only 2 are displayed.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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