+ Reply to Thread
Results 1 to 3 of 3

Add error bar to the bar chart for big data set

  1. #1
    Registered User
    Join Date
    10-21-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    15

    Add error bar to the bar chart for big data set

    Hello everyone,

    I have a big data set which I need to draw the bar chart with calculated error bar (SD).
    Can you please help since I do not want to add the error bar one by one?

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Add error bar to the bar chart for big data set

    I don't know why you expect to need to add them one by one. It should be as easy as:

    1) Add error bars
    2) Format error bars to use "custom" values, then point that field to use the corresponding row of standard deviation values
    3) Repeat for each data series.

    https://support.office.com/en-us/art...5-864049a145f0
    or https://blog.udemy.com/adding-error-bars-in-excel/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    10-21-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    15

    Re: Add error bar to the bar chart for big data set

    Dear MrShorty,

    Because this data set is a small part of my current data.
    I need to draw a chart for 20 means+SD and I have to repeat this chart for different 5 classes of observation (the number of observations in each class is differed).
    Basically, I can add the error bar for each data series, however, it takes a long time to finish.
    I want to help for the way to clone the graph of set up the way to draw quicker.
    Thanks.

+ 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. wrong data error in pie chart
    By royaldex in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-27-2015, 12:20 PM
  2. Replies: 5
    Last Post: 07-16-2011, 08:07 AM
  3. Setting a data range for a chart (error 1004).
    By HammerTime in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2010, 05:28 AM
  4. How to I incorporate SD from a data series into chart error bars?
    By carlosPharm.D in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-02-2005, 05:05 PM
  5. How to omit data in a chart when there are error values?
    By Bou in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-10-2005, 04:05 PM
  6. [SOLVED] Update data and Y error bars in a chart
    By Raul in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2005, 01:06 PM
  7. changing chart data generates error!
    By cell division in forum Excel General
    Replies: 1
    Last Post: 01-15-2005, 06:50 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