|
Size: 1976
Comment:
|
← Revision 17 as of 2015-11-10 14:01:06 ⇥
Size: 2304
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 2: | Line 2: |
For EXCEL 2007, 2010 and 2013 a slightly different approach is [[FAQ/errbar07| needed.]] You can also produce these [[FAQ/errbSPSS| in SPSS.]] |
|
| Line 3: | Line 6: |
| Enter the values of the variable to be plotted in one row and the standard errors pertaining to each variable column in another row. | Enter the means of the variable to be plotted in one column and the confidence interval half-width for each mean in another column. |
| Line 6: | Line 9: |
| Highlight the row containing the variable values | Click on the chart wizard icon (identified by a graph of coloured bars) or choose CHART on the INSERT toolbar. |
| Line 9: | Line 12: |
| Click on the chart wizard icon (identified by a graph of coloured bars) or choose CHART on the INSERT toolbar | Under '''CHART TYPE''' choose '''COLUMN''' and '''CLUSTERED COLUMN''' under '''CHART SUB-TYPE'''. Work through the windows adding titles for the '''x''' and '''y''' axes clicking on NEXT to move through the wizard prior to clicking on '''FINISH'''. |
| Line 12: | Line 15: |
| Under '''CHART TYPE''' choose '''COLUMN''' and '''CLUSTERED COLUMN''' under '''CHART SUB-TYPE'''. Work through the windows adding titles for the '''x''' and '''y''' axes clicking on NEXT to move through the wizard prior to clicking on '''FINISH''' | Doubleclick on any bar in the resultant graph. |
| Line 15: | Line 18: |
| Doubleclick on any bar in the resultant graph | Click on the tab called '''Y ERROR BARS''' in the resultant '''FORMAT DATA SERIES''' Window. |
| Line 18: | Line 21: |
| Click on the tab called '''Y ERROR BARS''' in the resultant '''FORMAT DATA SERIES''' Window | Click on the display named '''BOTH''' and choose '''CUSTOM'''. |
| Line 21: | Line 24: |
| Click on the display named '''BOTH''' and choose '''CUSTOM''' | Highlight the standard error row in the spreadsheet. The co-ordinates of the standard error row should appear in the ''''+'''' box in the '''CUSTOM''' section. |
| Line 24: | Line 27: |
| Highlight the standard error row in the spreadsheet. The co-ordinates of the standard error row should appear in the ''''+'''' box in the '''CUSTOM''' section 1. Click on the window adjacent to ''''-'''' and highlight the standard error row. The co-ordinates of the standard error row should appear in the ''''-'''' box |
Click on the window adjacent to ''''-'''' and highlight the standard error row. The co-ordinates of the standard error row should appear in the ''''-'''' box. |
| Line 32: | Line 32: |
| A similar approach can be used for adding error bars to [:FAQ/linebar line plots of means] for example, to illustrate 2-way interactions. | A similar approach can be used for adding error bars to [[FAQ/linebar|line plots of means]] for example, to illustrate 2-way interactions. |
| Line 34: | Line 34: |
| [Last updated on 27 November, 2003] | You can save confidence intervals and means in SPSS 12 or above for use for plotting in EXCEL using the [[FAQ/lbaroms|output management system]]. Mike Griffiths has put this [[attachment:explots.doc | MS Word guide]] together on producing a range of plots in EXCEL. |
| Line 37: | Line 39: |
| [wiki:FAQ Return to Statistics FAQ page] | [[FAQ|Return to Statistics FAQ page]] |
| Line 39: | Line 41: |
| [wiki:CbuStatistics Return to Statistics main page] | [[CbuStatistics|Return to Statistics main page]] |
| Line 41: | Line 43: |
| [http://www.mrc-cbu.cam.ac.uk/ Return to CBU main page] | [[http://www.mrc-cbu.cam.ac.uk/|Return to CBU main page]] |
| Line 43: | Line 45: |
| These pages are maintained by [mailto:ian.nimmo-smith@mrc-cbu.cam.ac.uk Ian Nimmo-Smith] and [mailto:peter.watson@mrc-cbu.cam.ac.uk Peter Watson] | These pages are maintained by [[mailto:ian.nimmo-smith@mrc-cbu.cam.ac.uk|Ian Nimmo-Smith]] and [[mailto:peter.watson@mrc-cbu.cam.ac.uk|Peter Watson]] |
Adding error bars to a bar graph in MS Excel 97
For EXCEL 2007, 2010 and 2013 a slightly different approach is needed. You can also produce these in SPSS.
- Enter the means of the variable to be plotted in one column and the confidence interval half-width for each mean in another column.
- Click on the chart wizard icon (identified by a graph of coloured bars) or choose CHART on the INSERT toolbar.
-
Under CHART TYPE choose COLUMN and CLUSTERED COLUMN under CHART SUB-TYPE. Work through the windows adding titles for the x and y axes clicking on NEXT to move through the wizard prior to clicking on FINISH.
- Doubleclick on any bar in the resultant graph.
-
Click on the tab called Y ERROR BARS in the resultant FORMAT DATA SERIES Window.
-
Click on the display named BOTH and choose CUSTOM.
-
Highlight the standard error row in the spreadsheet. The co-ordinates of the standard error row should appear in the '+' box in the CUSTOM section.
-
Click on the window adjacent to '-' and highlight the standard error row. The co-ordinates of the standard error row should appear in the '-' box.
-
Click OK You should now have a bar chart with error bars. Doubleclicking on the error bars and clicking the PATTERNS tab in the FORMAT ERROR BARS window allows the user to change the style, colour or thickness of the lines forming the error bars.
A similar approach can be used for adding error bars to line plots of means for example, to illustrate 2-way interactions.
You can save confidence intervals and means in SPSS 12 or above for use for plotting in EXCEL using the output management system.
Mike Griffiths has put this MS Word guide together on producing a range of plots in EXCEL.
Return to Statistics main page
These pages are maintained by Ian Nimmo-Smith and Peter Watson