+ Reply to Thread
Results 1 to 3 of 3

Different error bars on same line.

Hybrid View

I2est Different error bars on same... 03-27-2009, 03:50 PM
Mallycat Re: Different error bars on... 03-27-2009, 05:37 PM
I2est Re: Different error bars on... 03-27-2009, 10:23 PM
  1. #1
    Registered User
    Join Date
    03-27-2009
    Location
    Santa Cruz, California
    MS-Off Ver
    Excel 2007
    Posts
    2

    Different error bars on same line.

    I have a line graph with 2 points on it and a line connecting them. At each point, I have added error bars. I would like to have different values for each error bar but do not know how to do so.

    I would like to have the error bar at the first point have a value of 0.74 and the error bar at the second point have a value of 0.58.

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: Different error bars on same line.

    In Excel 2007, you can specify 'custom' error bars and then point to a range in the sheet. I assume you can do this with earlier versions.

  3. #3
    Registered User
    Join Date
    03-27-2009
    Location
    Santa Cruz, California
    MS-Off Ver
    Excel 2007
    Posts
    2

    Smile Re: Different error bars on same line.

    I figured it out:
    1. The different margin or percentage error values must be placed inline on a row or column.
    2. Then from the Format Error Bars window, select Custom, click on Specify Value.
    3. Set the positive or negative values to the entire row or column the error values were placed.
    4. The values will be placed on points in order the error values were listed listed.

    Thanks for the help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1