Saturday, May 12, 2012

How to Make a Chart With Standard Errors in Microsoft Graph


1. Type your data into Excel using a column format. For example, if you are creating a chart for children's test scores, type the names of the children in the first column, then type the test scores in the second column.
2. Highlight the data in the document. Click at the top left, then drag the cursor to the bottom right.
3. Click 'Insert,' then click 'Chart.' Follow the instructions on the Chart Wizard to create a graph of your choice.
4. Double click a series on the chart, then press 'Ctrl' and '1' to open the Format Series dialog box.
5. Click either the 'X Error Bars,' or the 'Y Error Bars' tab, depending on what type of error bar you want to add.
6. Click an icon that represents the specific error bar you want to add. The choices are 'Both,' 'Plus,' 'Minus,' or 'None.'
7. Click a radio button for the error amount, and type an amount into the error text box. For example, click the radio button for 'Fixed value,' then type '2' into the text box.
8. Click 'Ok.'

Blogger news