+ Reply to Thread
Results 1 to 5 of 5

1. How create grouped bars. 2. and how to manualy put in individual standard error

  1. #1
    Registered User
    Join Date
    01-02-2014
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    3

    1. How create grouped bars. 2. and how to manualy put in individual standard error

    Hey folks

    Have been searching these questions without any luck and found this forum ! I am a pretty noobie on this and are trying following without success:

    1. Create bars in groups/group bars - how do you group certain bars together in charts?

    2. Put in standard errors in each bar - whenever I do it, excel wants to have the same standard error in all bars - how put in individual standard errors in each bar?

    Am using excel 2010

    Pure graphicaly I want it to look something like this:
    Bar_charts_with_error-_bars_JMP.jpg

    Thanks, appreciate any help on these very much
    Last edited by BlackSwan2; 01-02-2014 at 06:53 AM.

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: 1. How create grouped bars. 2. and how to manualy put in individual standard error

    Sample workbook is more useful than picture. The picture looks like simple three series clustered bar chart.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

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

    Re: 1. How create grouped bars. 2. and how to manualy put in individual standard error

    See here for information on error bars.
    http://peltiertech.com/WordPress/err...in-excel-2007/

    You need to use custom values
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    01-02-2014
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: 1. How create grouped bars. 2. and how to manualy put in individual standard error

    Anyone who can actually reply to the question(s): how to group a bunch of individual bars in excel 2010 with individual standard error on each bar?

  5. #5
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: 1. How create grouped bars. 2. and how to manualy put in individual standard error

    BlackSwan2,

    1) The excellent suggestion in post #2 should be followed if you're looking for specific hand-holding in your workbook.

    2) The link in post #3 is a complete primer for error bars and includes sections for pre-2007 and 2007+ versions of Excel.

    3) The accidental (?) attitude in post #4 was probably not a good idea.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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: 2
    Last Post: 03-28-2012, 02:29 PM
  2. Error Bars-standard deviations
    By shantibala in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-04-2008, 09:01 PM
  3. Standard Error Bars.
    By A S-D in forum Excel General
    Replies: 1
    Last Post: 07-05-2006, 06:52 AM
  4. [SOLVED] Calculate and display individual error bars for individual points
    By del in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-30-2006, 11:30 PM
  5. Replies: 2
    Last Post: 04-05-2005, 06:06 AM

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