Diff for "FAQ/errbar07" - CBU statistics Wiki
location: Diff for "FAQ/errbar07"
Differences between revisions 6 and 9 (spanning 3 versions)
⇤ ← Revision 6 as of 2010-10-26 13:08:17 →
Size: 2963
Editor: PeterWatson
Comment:
← Revision 9 as of 2010-11-03 11:52:30 → ⇥
Size: 2627
Editor: PeterWatson
Comment:
Deletions are marked like this. Additions are marked like this.
Line 5: Line 5:
 1. Click on '''INSERT''' on menu bar and select '''LINE''' in the '''CHARTS''' section at the top of the spreadsheet  1. Click on '''INSERT''' on menu bar and doubleclick on '''COLUMN''' in the '''CHARTS''' section at the top of the spreadsheet.
Line 7: Line 7:
 1. Choose '''LINE WITH MARKERS''' (leftmost chart on 2nd row from the top).

 1. A graph should appear. Drag the graph away from the spreadsheet data so you can clearly see both the graph and data in the spreadsheet.

 1. Click on any marker (data point) shown in the graph.		  1. Choose '''2-D COLUMN CLUSTERED''' (leftmost chart on 1st row from the top).
Line 15: Line 11:
 1. In the left window labelled Legend Entries (Series) click '''ADD'''.  1. In the left window labelled '''LEGEND ENTRIES (SERIES)''' click '''ADD'''.
Line 17: Line 13:
 1. In the '''SERIES NAME''' box type in Males; Delete all contents in the Series Values box directly beneath and click the spreadsheet icon immediately to the right of the Series Values box.  1. In the '''SERIES NAME''' box type in Males; Delete all contents in the '''SERIES VALUES''' box directly beneath and click the spreadsheet icon immediately to the right of the '''SERIES VALUES''' box.
Line 19: Line 15:
 1. Highlight cells A2 to A4 in the column representing the means (these should appear in the Series Values box). Click '''OK'''.  1. Highlight cells A2 to A4 in the column representing the means (these should appear in the '''SERIES VALUES''' box). Click '''OK'''.
Line 21: Line 17:
 1. Highlight ‘width’ in the Legend Entries (Series) box and click '''EDIT'''.  1. In the left window labelled '''LEGEND ENTRIES (SERIES)''' click '''ADD'''.
Line 23: Line 19:
 1.  Repeat steps 7 and 8 above typing Females into the '''SERIES NAME''' box. Delete all contents in the '''SERIES VALUES''' box directly beneath and click the spreadsheet icon immediately to the right of the '''SERIES VALUES''' box.  1. Repeat steps 5 and 6 for Females: in the '''SERIES NAME''' box type in Females, delete all contents in the '''SERIES VALUES''' box directly beneath and click the spreadsheet icon immediately to the right of the '''SERIES VALUES''' box.
Line 25: Line 21:
 1.  Highlight cells A5 to A7 in the column representing the means (these should appear in the '''SERIES VALUES''' box). Click '''OK'''.  1. Highlight cells A5 to A7 in the column representing the means (these should appear in the '''SERIES VALUES''' box). Click '''OK'''.
Line 27: Line 23:
 1. Highlight ‘mean’ in the '''LEGEND ENTRIES (SERIES)''' and click REMOVE.

 1. Now highlight Males in the '''LEGEND ENTRIES (SERIES)''' and go to the '''HORIZONTAL (CATEGORY) AXES LABELS''' box and Click EDIT. 		 1. Click '''EDIT''' in the '''HORIZONTAL (CATEGORY) AXIS LABELS''' box.
Line 33: Line 27:
 1. Now doubleclick on a marker representing males in the graph and choose '''LAYOUT''' in the top spreadsheet menu and in the '''ANALYSIS''' section click '''ERROR BARS>MORE ERROR BARS OPTIONS''' and choose '''CUSTOM''' and click '''SPECIFY VALUE'''.  1. Now doubleclick on any bar representing males in the graph and choose '''LAYOUT''' in the top spreadsheet menu and in the '''ANALYSIS''' section click '''ERROR BARS>MORE ERROR BARS OPTIONS''' and choose '''CUSTOM''' and click '''SPECIFY VALUE'''.
Line 35: Line 29:
 1. Click on the spreadsheet adjacent to the box under '''POSITIVE ERROR VALUE''' and highlight cells B2 to B4 in the width (standard error) column. The co-ordinates of the standard error row should appear in the '''POSITIVE ERROR VALUE''' box. Repeat for the '''NEGATIVE ERROR VALUE''' box again highlighting cells B2 to B4. Click '''OK''' and '''CLOSE'''.  1. Click on the spreadsheet icon adjacent to the box under '''POSITIVE ERROR VALUE''' and highlight cells B2 to B4 in the width (standard error) column. The co-ordinates of the standard error row should appear in the '''POSITIVE ERROR VALUE''' box. Repeat for the '''NEGATIVE ERROR VALUE''' box again highlighting cells B2 to B4. Click '''OK''' and '''CLOSE'''.
Line 37: Line 31:
 1. Repeat steps 15 and 16 for females by clicking on a marker representing females and placing cells B5 to B7 in the '''POSITIVE ERROR VALUE''' and '''NEGATIVE ERROR VALUE''' boxes.  1. Repeat steps 15 and 16 for females by clicking on any bar representing females and placing cells B5 to B7 in the '''POSITIVE ERROR VALUE''' and '''NEGATIVE ERROR VALUE''' boxes.
Line 39: Line 33:
 1. Click '''OK''' and '''CLOSE'''. 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.  1. Click '''OK''' and '''CLOSE'''. You should now have a bar chart with error bars. Doubleclicking on the bars and clicking the '''FORMAT''' tab in the menu bar located at the top of the spreadsheet allows the user to change the style and colour of the bars.

Putting error bars on graphs using EXCEL 2007

(This a bit more convoluted than in earlier versions of EXCEL but uses exactly the same strategy)

  1. Click on INSERT on menu bar and doubleclick on COLUMN in the CHARTS section at the top of the spreadsheet.

  2. Choose 2-D COLUMN CLUSTERED (leftmost chart on 1st row from the top).

  3. In the DATA section at the top of the spreadsheet click SELECT DATA.

  4. In the left window labelled LEGEND ENTRIES (SERIES) click ADD.

  5. In the SERIES NAME box type in Males; Delete all contents in the SERIES VALUES box directly beneath and click the spreadsheet icon immediately to the right of the SERIES VALUES box.

  6. Highlight cells A2 to A4 in the column representing the means (these should appear in the SERIES VALUES box). Click OK.

  7. In the left window labelled LEGEND ENTRIES (SERIES) click ADD.

  8. Repeat steps 5 and 6 for Females: in the SERIES NAME box type in Females, delete all contents in the SERIES VALUES box directly beneath and click the spreadsheet icon immediately to the right of the SERIES VALUES box.

  9. Highlight cells A5 to A7 in the column representing the means (these should appear in the SERIES VALUES box). Click OK.

  10. Click EDIT in the HORIZONTAL (CATEGORY) AXIS LABELS box.

  11. Delete any contents In the AXES LABEL RANGE box, and insert {“NE”,”SE”,”W”} and click OK.

  12. Now doubleclick on any bar representing males in the graph and choose LAYOUT in the top spreadsheet menu and in the ANALYSIS section click ERROR BARS>MORE ERROR BARS OPTIONS and choose CUSTOM and click SPECIFY VALUE.

  13. Click on the spreadsheet icon adjacent to the box under POSITIVE ERROR VALUE and highlight cells B2 to B4 in the width (standard error) column. The co-ordinates of the standard error row should appear in the POSITIVE ERROR VALUE box. Repeat for the NEGATIVE ERROR VALUE box again highlighting cells B2 to B4. Click OK and CLOSE.

  14. Repeat steps 15 and 16 for females by clicking on any bar representing females and placing cells B5 to B7 in the POSITIVE ERROR VALUE and NEGATIVE ERROR VALUE boxes.

  15. Click OK and CLOSE. You should now have a bar chart with error bars. Doubleclicking on the bars and clicking the FORMAT tab in the menu bar located at the top of the spreadsheet allows the user to change the style and colour of the bars.

None: FAQ/errbar07 (last edited 2015-11-10 14:00:49 by PeterWatson)