I recently upgraded from Office 2003 to Office 2010 and quickly regretted it. While Microsoft continually makes their programs more visually appealing, very rarely do they add any improvement in functionality, and quite often, things only seem to get worse.
(On a related note, I recently read that Internet Explorer is the only web browser still using a faulty method for interpreting CSS layouts, which is why for the forseeable future, all webpage files will have to begin with an otherwise unnecessary piece of code that does nothing but tell IE to behave properly.)
Anyway, as a scientist, I'm always using error bars. Error bars are a visual way of representing the uncertainty associated with a measurement ... and they are critical for everything we do. No data is meaningful unless one can ascribe an estimate of how close a measured value might be to a true value - a number we can never be totally confident of. So error bars are important. And they keep getting harder and harder to find.
Starting with Excel 2007, functions are organized under "tabs" rather than "menus". More to the point, there are a second set of tabs associated with charts - a tab for the tabs as it were.
To find the custom error bars, you first click "More error bar options ...", THEN click Custom, at the very bottom of the menu. THEN you have to click "Specify Value".
To my knowledge, there's no way to create a macro to speed this up, and you have to repeat the whole process for every single chart you make, even very similar ones. I realize Excel was never built for scientists. But data is data and error is error. I don't understand why such a simple and useful feature has to be harder to find than that potion in Prince of Persia where you have to knock open a secret ceiling tile and then time a jump through three chompers. It's a just a spreadsheet.