How to Make an Excel Line Graph - Ms. Brannagan's Page



How to Make an Excel Line Graph

1. Open Excel and enter titles and data values in the spreadsheet. Your spreadsheet should look like this below.

[pic]

2. Select the data sets.

[pic]

3. Once the data set is selected, choose INSERT and CHART. Once the window for CHART Wizard opens, choose LINE.

Follow the instructions through the CHART Wizard (all editions are a little different). Add in your information for the axes titles and for the chart title.

[pic]

Your final project should look something like this. If you do not have the labels on the axes and the chart title, right click on the graph and select Chart Options to add in the axes and chart titles.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download