+ Reply to Thread
Results 1 to 4 of 4

2013 Error Bars

Hybrid View

  1. #1
    Registered User
    Join Date
    01-12-2016
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013
    Posts
    2

    2013 Error Bars

    Greetings!
    Long time viewer; never had to post before because I have always been able to find my question already answered.Thank you to everyone for the numerous jams this community has gotten me out of. I apologize in advance if this has already been answered or I am not following a rule.

    I have sets of data by year. For each year I am plotting one average value for that year as a function of the year. i.e. X axis is year (1915-2014) and Y axis is the average value. These have been plotted as xy scatter. Very simple.

    I also have a calculated error value for each of the averages values on the Y axis. I.e. deviation of the full year data set set from the average. I would like error bars added for each point. And I did but there are issues.

    I used the + sign and toggled on "error bars". Went to more options and used custom data. The heading is vertical error bars. All is good except that the error bars are extending horizontally when they should be vertical.

    So I thought: perhaps if I install "horizontal" error bars, they will be vertical; similar to what is already happening. Unfortunately, I only seem to have the "vertical" error bar option. There is no option or heading for "horizontal".

    Any suggestions on how to get truly vertical error (bar is vertical) on the plot would be much appreciated.

    Thank you!

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

    Re: 2013 Error Bars

    You would need to use xy-scatter chart to have both vertical and horizontal error bars.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-12-2016
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013
    Posts
    2

    Re: 2013 Error Bars

    Thank you Andy.
    The plot is an xy scatter.

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

    Re: 2013 Error Bars

    If it is an xy-scatter then when you apply error bars both x and y error bars are applied.

    You should be able to use the Selection drop down, can be found on ribbon, Chart Tools > Format > Current selection, to pick x or y error bars for further formatting.

    If not you would need to post example workbook so we can investigate.


    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ 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. Individual Error Bars Excel 2013
    By PleaseHelpMeQuick in forum Excel General
    Replies: 4
    Last Post: 04-25-2015, 07:59 AM
  2. Replies: 2
    Last Post: 10-30-2014, 05:48 PM
  3. Replies: 3
    Last Post: 07-20-2014, 11:46 AM
  4. Adding Individual Error Bars Excel 2013
    By EllieLinc in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-19-2013, 12:18 PM
  5. Replies: 2
    Last Post: 03-28-2012, 02:29 PM
  6. Range bars, not error bars
    By Anselm in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-14-2010, 12:38 AM
  7. chart: error bars with custom error range
    By brickc1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-26-2009, 11:52 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