+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Standard deviation error bars don't work

  1. #1
    Registered User
    Join Date
    08-17-2010
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    6

    Standard deviation error bars don't work

    Hiya!

    I'm Running Excel 2007 on Vista. Trying to put error bars on a bar chart. Standard error works fine but standard deviation doesn't work - I get a row of bars the same length, hovering way above the top of the data series bars in a straight line. Did all latest updates this morning. Is this incurable Vista weirdness? Anybody experienced this or knows how to fix it??? Cheers!

  2. #2
    Registered User
    Join Date
    08-17-2010
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Standard deviation error bars don't work

    Aaah I solved it. If you just select standard deviation (or standard error?) it doesn't really do anything useful - just puts some random lines on the graph that are all the same length (average for all bars?). To add actual standard deviation / error put your pre calculated values in a row, in the same order as the data bars, and clicky clicky error bars / more error bar options / custom and chuck in your row of values for positive and negative values. Hope this helps!

+ 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