The error bar technique on my website works just fine in Excel 2007...almost
fine.

The simple mechanism I remember for Excel 2007 is this. When specifying
custom ranges, always also specify that you want both 'both' plus and minus
error bars. Then, in the custom range dialog box set the one that you don't
want to zero.

So, suppose you have the horizontal error bar values in C2:C5 (and C6 is
empty). Then, to create only plus error bars for the horizontal error bars,
in the error bar dialog box specify 'both' and in the custom range dialog
box, for the plus values select the range C2:C6 and in the minus values box
enter 0.
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"Theresa9599" wrote:

I also keep on forgetting to mention that I am using Excel 2007, if that
makes any difference.