Standard deviation error bars don't work
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!
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!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
- 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