+ Reply to Thread
Results 1 to 2 of 2

Error Bars (Vertical)

  1. #1
    Registered User
    Join Date
    10-24-2014
    Location
    Iceland
    MS-Off Ver
    2013
    Posts
    9

    Error Bars (Vertical)

    Hi.

    I'm making tables and charts for steel's corrosion weight loss for few samples. I don't know how to select data for the Error Bar for my data.

    Quick overview of the file:
    • Sheet - "Weight": Input weights of steel samples.
    • Sheet - "D-Weight": Calculating the Delta-Weight. I.e. the weight loss since beginning.
    • Sheet - "P-Weight": Calculating the weigh loss percentage. I.e. the weight loss since beginning.
    • Sheet - "Ave-Stdev": Calculating average of weight loss for each subgroup and standard deviation.

    Extra info for deeper understanding of the file.
    40 samples total. Marked X.Y.Z
    • X = Group (1,2)
    • Y = Subgroup (1,2,3,4,5)
    • Z = Sample Numbers (1,2,3,4)

    What I'm trying to do is: Make scatter plot with the results in "Sheet-Stdev" with error bar. I don't know how to select row for the error bar for each group/subgroup.

    Here is the .xlsx file - Hope someone can help me. mælingar.xlsx
    Thanks, in advance.
    Bjartmar

  2. #2
    Registered User
    Join Date
    10-24-2014
    Location
    Iceland
    MS-Off Ver
    2013
    Posts
    9

    Re: Error Bars (Vertical)

    Oh, I think I found this out myself.

    Solution:
    1. Select the chart.
    2. Press the [+] on the top right.
    3. Tick at "Error bars"
    4. Repeat 1,2. Press the arrow on the right to the "Error bar"
    5. Press "Standard Deviation"
    6. Repeat 1,2. Press the arrow on the right to the "Error bar"
    7. Press "More Options".
    8. Choose legend to add error bar.
    9. Select data for + and - error for chosen legend.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 07-16-2011, 08:07 AM
  2. Chart issue with Vertical Error bars past 21 plot points
    By maacmaac in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-02-2010, 09:45 AM
  3. how to create vertical bars/shading
    By krs1 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-08-2007, 03:55 PM
  4. add only vertical error bars to a single data point in a series.
    By cwagner in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-24-2007, 03:27 PM
  5. [SOLVED] horizontal & vertical scroll bars
    By labrev in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2005, 12:06 PM

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