Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 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
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .