Horizontal Error Bars in Excel 2007
 

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

Thanks,
Barb Reinhardt

Answer: Horizontal Error Bars in Excel 2007
 

Hi Barb,

Yes, it is definitely possible to add horizontal error bars in Excel 2007. Here's how you can do it:

1. First, select the data series to which you want to add the horizontal error bars.
2. Next, click on the "Layout" tab in the ribbon at the top of the screen.
3. In the "Analysis" group, click on the "Error Bars" button and select "More Error Bar Options" from the dropdown menu.
4. In the "Format Error Bars" dialog box that appears, click on the "Error Bars" tab.
5. Under "Error Amount," select the "Custom" option and click on the "Specify Value" button.
6. In the "Custom Error Bars" dialog box, click on the "Custom" option under "Error Amount."
7. Now, you can enter the values for your horizontal error bars. You can either enter a constant value, or you can select a range of cells that contain the values you want to use.
8. Once you have entered your values, click "OK" to close the dialog boxes.

Your horizontal error bars should now be visible on your chart. If you need to make any adjustments, you can always go back to the "Format Error Bars" dialog box and make changes as needed.

Horizontal Error Bars in Excel 2007
 

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

Horizontal Error Bars in Excel 2007
 

I have tried these instructions and Jon Peltier's forum and still cannot add
X-error bars. I have an X-Y scatter plot, and when I add error bars it is
only vertical. If I click on my series with the error bar modeless dialog
box on the screen, I can only click on the vertical error bars. how can I
click on (to select) horizontal error bars if they don't seem to exist? So
very frustrating. Give me Excel 2002 back.

"John Mansfield" wrote:

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

Horizontal Error Bars in Excel 2007
 

The error bars are there, if it is in fact an XY chart and not a line
chart. The arbitrary value Excel assigns may make them too short to see
behind the oversized Excel 2007 markers. You can select them using the
dropdown in the top left of the Chart Tools Layout and Format tabs.

You could also try out the (free!) utility on my web site:

Error Bars in Excel 2007 Charts | PTS Blog
http://peltiertech.com/WordPress/err...in-excel-2007/

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



jaymongrel wrote:
I have tried these instructions and Jon Peltier's forum and still cannot add
X-error bars. I have an X-Y scatter plot, and when I add error bars it is
only vertical. If I click on my series with the error bar modeless dialog
box on the screen, I can only click on the vertical error bars. how can I
click on (to select) horizontal error bars if they don't seem to exist? So
very frustrating. Give me Excel 2002 back.

"John Mansfield" wrote:

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