Thursday, April 25, 2013

How to Create Line Graphs With Two Groups in Microsoft Excel

1. Open the Microsoft Excel file that contains the data sets you wish to graph.
2. Click the 'Chart' button on the Excel toolbar. A pop-up chart wizard will appear.
3. Select the 'XY Scatter' chart type and any chart sub-type you prefer. The options provide four types of line graphs to suit your style. Press the 'Next' button.
4. Delete anything that is displayed in the 'Data Range' field. Select the 'Columns' option in the 'Series in' field. Then click the 'Series' tab.
5. Create a new series for each line you wish to graph based on a group of data. If you have two groups of data, you will create two series. Click the 'Add' button twice to create these two series.
6. Click on the first series in the 'Series' list box.
7. Type the name of this series in the 'Name' field. Specify the ranges for the X values and Y values of this first line group separately in the two other fields.
8. Click the second line group series in the 'Series' list box and fill in the same fields. Press the 'Next' button to customize the visual details of the chart, if desired, or alternately press the 'Finish' button to display the graph.
9. Right-click on each line or XY scatter plot and select the 'Format Data Series' option if you wish to alter how the lines display. This is useful if the lines are close together so each is uniquely identified.

Blogger news