How to Create a Line Chart in Excel 2007

1. Enter in headers for all of your data columns. Just type in the name for each data field in the cell directly above the data. If your data doesn't have an available row of cells above it, right-click on the row number that corresponds to the top row of data, and choose 'Insert.' These headers will be the labels for your data on the line chart.
2. Type in the row labels in the column directly to the left of your data. If you don't have any empty cells to enter in information, right-click on the letter at the top of the leftmost data column and select 'Insert.' These labels will appear at the bottom of the line chart to show the progression of your data. If you don't enter these labels, the chart will default to numerical labels, staring at one and counting upward.
3. Select the cell above the row labels and to the left of the column headers. Hold the shift key and select the bottom-right cell in your data field.
4. Click on the 'Insert' tab at the top of the Excel ribbon. Locate the 'Charts' area, and select 'Line.' Choose between the seven different types of line charts. You can choose between a standard line chart, stacked line chart and 100 percent stacked line chart. A stacked line will add all the data fields together, instead of comparing them like a regular line chart. A 100 percent stacked line will add all the items together, and then display each item's percentage of that total. Each of these options is also available with markers along the data lines. You can also choose to create a 3D lines chart. Once you select the line chart type, your line chart appears on the screen.