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
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
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/
Originally Posted by shg
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks