Hi Barb,

Yes, they still exist but they're not easy to find. If you have an XY chart
for example, click on the outside edge. In the layout tab go to the analysis
group. Select Error Bars - More Error Bar Options. It should then add
vertical and horizontal error bars to your chart. However, the Format Error
Bars dialog box indicates only Vertical Error Bars. What is hard to see is
that the dialog box is modeless. So, while it's still on your screen you can
click on the error bars in the chart. As you click on a horizontal error
bar, the dialog box will switch to a horizontal mode. When you click on a
vertical error bar, it then goes to the vertical mode. Seems like it was a
lot easier in Excel 2003.

Jon Peltier has a blog post that covers this behavior:

http://peltiertech.com/WordPress/err...in-excel-2007/

----
John Mansfield
http://www.cellmatrix.net


"Barb Reinhardt" wrote:

Is it possible to still do this in Excel 2007? I can find Vertical, but not
horizontal.

Thanks,
Barb Reinhardt