![]() ![]() If Excel defaults to grey as a color (it did this for Excel 2013, but it doesn't seem to in Excel 2016), there is an easy fix.Ĭlick on the paint can icon at the top of the "Format Error Bars" You will have to click on the tab at the bottom to go to the worksheet where your data are.Ĭlick "OK", and you should have the correct error bars in your graph. The positive and negative error values, as the error is the same magnitude in both directions (remember, this is just In the same way you selected the values for your graph, select the 2 standard errors from the table you made for both Will bring up a selection box that should look somewhat familiar: The button to the right that says "Specify Value". At the very bottom of the menu (blue arrow on the preceding picture) click on the circle next to "Custom", and then click on ![]() It won't give you the correct error bars. Ignore the "Standard Error" option on this menu. Have to click on the icon with the bars (red arrow below) to get to the correct menu: This will bring up a large "Format Error Bars" menu on the right-hand side of your screen. See that grey arrow that appeared next to "Error Bars" when you checked the box?Ĭlick on that (as indicated by the red arrow above) to access the dropdown menu (also shown above), and click on ![]() The first step is to click on the plus sign in the upper right-hand corner of your graph, to bring up the "Chart Elements"Ĭlick on the box next to "Error Bars", as indicated by the red arrow above, to add the wrong error bars. Speaking of checking up, when was the last time you saved your Make sure to check that the values on the graph match those that youĬalculated when you have completed all of the steps. If you make a mistake, Excel will add the wrong error bars. Error Bars - Excel 2016 Adding Error BarsĪdding error bars is not too difficult, but does take a few more steps in Excel than it probably should. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |