+ Reply to Thread
Results 1 to 5 of 5

Excel Scatter Plot Error Bars All Show Same Standard Deviation

  1. #1
    Registered User
    Join Date
    01-20-2015
    Location
    California
    MS-Off Ver
    2010
    Posts
    3

    Excel Scatter Plot Error Bars All Show Same Standard Deviation

    I have a scatter plot with a range of distance points (Y axis) according to year (X axis). When I create vertical error bars, all the standard deviations are identical even though the data ranges are completely different for each year.


    Also, how do you change the label names for items in the legend?
    SpecialChart.jpg

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Excel Scatter Plot Error Bars All Show Same Standard Deviation

    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
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    01-20-2015
    Location
    California
    MS-Off Ver
    2010
    Posts
    3

    Re: Excel Scatter Plot Error Bars All Show Same Standard Deviation

    Attached is the workbook. Not sensitive.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by spaine; 01-20-2015 at 02:04 PM. Reason: No attachment

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Excel Scatter Plot Error Bars All Show Same Standard Deviation

    It's because Excel has calculated 1 SD of ALL of the data, not sorted by years. take a look at this as a first cut.

  5. #5
    Registered User
    Join Date
    01-20-2015
    Location
    California
    MS-Off Ver
    2010
    Posts
    3

    Re: Excel Scatter Plot Error Bars All Show Same Standard Deviation

    OK, so we have to calculate averages and standard deviations on our own and tell Excel to use those values. Seems kind of clunky. Thanks for your help!

+ 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. [SOLVED] Standard Deviation Error Bars for Individual Columns of a Bar Chart
    By Chris_SS in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-08-2014, 04:35 AM
  2. Replies: 4
    Last Post: 09-04-2013, 11:15 PM
  3. Shaded Standard Deviation or Error Bars
    By SillayKetha in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-20-2013, 01:24 AM
  4. Excel 2007 : Standard deviation error bars don't work
    By Marinegirl in forum Excel General
    Replies: 1
    Last Post: 08-17-2010, 03:26 PM
  5. error bars and standard deviation
    By Emily Stevens in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-17-2007, 11:08 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