Results 1 to 4 of 4

Thread: How to get Horizontal Error Bars in Excel 2007

  1. #1
    Join Date
    Jan 2011
    Posts
    26

    How to get Horizontal Error Bars in Excel 2007

    How to get Horizontal Error Bars in Excel 2007, is it possible to still do this in Excel 2007. I can find Vertical, but not horizontal.

  2. #2
    Join Date
    Aug 2011
    Posts
    566

    Re: How to get Horizontal Error Bars in Excel 2007

    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.

  3. #3
    Join Date
    Jul 2011
    Posts
    623

    Re: How to get Horizontal Error Bars in Excel 2007

    I have tried these instructions but 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.

  4. #4
    Join Date
    Jul 2011
    Posts
    634

    Re: How to get 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 of Excel assigns may make them too short to see behind the oversize Excel 2007 markers. You can select them using the dropdown in the top left of the Chart Tools > Layout and Format tabs.

Similar Threads

  1. Replies: 6
    Last Post: 29-06-2012, 10:52 AM
  2. Need help to add error bars in every data point of Excel
    By cupid! in forum MS Office Support
    Replies: 1
    Last Post: 25-02-2012, 11:32 AM
  3. Adding scroll bars to images in excel sheet
    By arungiles in forum Tips & Tweaks
    Replies: 1
    Last Post: 05-08-2011, 03:37 PM
  4. Embedded Excel 2007 workbook gives error in Word 2007.
    By Milo D in forum Windows Software
    Replies: 5
    Last Post: 25-04-2011, 06:56 AM
  5. Samsung LN-T5271F problem: intermittent horizontal jittery bars
    By Chasey in forum Monitor & Video Cards
    Replies: 6
    Last Post: 01-05-2010, 09:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,673,389.81753 seconds with 17 queries