Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am attempting to draw error bars on a multiple bar graph in Excel 2007, and I am having trouble with the custom error bar minimum value. First, I created the graph from multiple series, then I calculated the Y-Value that the top and bottom of the error bar should be placed at, then I used the Table->Format->Error Bars->More dialog and clicked on the custom button. I then input the series error max and min into their respective boxes. However, the minimum value did not show up. What am I doing wrong?

P.S. I am using a Log2 Y axis, if that is any help.

share|improve this question

migrated from math.stackexchange.com Jul 7 '12 at 15:50

This question came from our site for people studying math at any level and professionals in related fields.

    
There isn't really enough data here to provide an answer. Can you please put up some sample data - maybe use a Google Spreadsheet. Then we can have a go at resolving the issue. –  Julian Knight Jul 19 '12 at 21:17

1 Answer 1

up vote 1 down vote accepted

Probably you've abandoned the question, but here goes:

In a range of the worksheet, place not the values of the ends of the error bars, but the lengths of the error bars. Use these ranges as the custom error bar values.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.