+ Reply to Thread
Results 1 to 2 of 2

Adding individual standard deviation lines

  1. #1
    Registered User
    Join Date
    05-04-2015
    Location
    Reading, England
    MS-Off Ver
    2013
    Posts
    5

    Adding individual standard deviation lines

    Dear all

    I have created a bar chart which consists of two groups mapped across a ten year period. I want to add the standard deviation for each group, per year. I can add standard deviations but what I'm finding is that Excel then places the same standard deviation for every year.

    My question, is how do I amend the standard deviation per group, per year individually?

    Forgive me, I'm a little shaky on data matters!

    Thank you to anyone who is able to help.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Adding individual standard deviation lines

    If you are using error bars to show the deviation then you can use the Custom error bar option to define the deviation for each data point.

    If you need more help post example file

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Cheers
    Andy
    www.andypope.info

+ 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. [SOLVED] adding mean and standard deviation values to chart while having % values
    By doters in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-19-2017, 05:09 PM
  2. [SOLVED] Standard Deviation Error Bars for Individual Columns of a Bar Chart
    By Chris_SS in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-08-2014, 04:35 AM
  3. VBA for Adding A Standard Text On First Blank Lines
    By angelab in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-29-2014, 01:39 PM
  4. Adding standard deviation bands to simulations
    By Yoshi64 in forum Excel General
    Replies: 1
    Last Post: 04-30-2014, 01:15 PM
  5. Excel 2007 : standard deviation
    By Jerseynjphillypa in forum Excel General
    Replies: 6
    Last Post: 06-15-2012, 12:21 PM
  6. Individual Standard Deviation Values for Each Column
    By Maurice. in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-14-2009, 11:48 PM
  7. Charting Standard Deviation of Trend Lines
    By Potatosalad2 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-11-2007, 12:34 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