Excel2010 How to add error bars when making a chart

In the use of Office software excel in the production of charts, in some cases, the chart series will not express enough accuracy, error between the data, to increase the error bar to the icon can easily solve the problem, the error bar refers to the series of values and the actual value of the deviation of a line, Only in this way can we let our charts express more accurate, the following is a detailed production of tutorials, you can refer to the following.

Error bars are used to reflect the range of deviations for a baseline for example: After you set the error value, select the most appropriate trendline and its predicted result by adding a trendline to see if the trendline remains within the error range.

If you have more than Office 2007, select the chart, the Ribbon-> Chart tool-> layout-> The right side has an error bar, as you need to choose to add.

Or:

Enter Excel for each set of mean values and corresponding standard deviations, then right, select the data series format, select the error line y, show the way positive deviation or other types, the final error amount, select a custom option, all the standard deviation of your data can be selected (note If only a single selection of all values show only that standard deviation), It's all done.

1, open the Excel chart, select the error bars, right-click, from the Drop-down menu, select the "Format error bar" option.

2. Open the Format Error Bar dialog box, switch to the vertical error bar panel, click the Positive and negative deviations option in the Display direction combo box, and then click the Close button.

3, return to Excel table, you can see the error bar display mode has changed. It just fits our requirements.

Three steps to get it done ~

Note : More wonderful tutorials Please pay attention to the triple computer Tutorials section, triple Office group: 185219299 welcome you to join