How to Make a Line Chart in Excel 2007

1. Enter data that will be charted into the spreadsheet. Line charts allow you the flexibility to present the information in rows or columns. Include text headers to identify what data is in the row or column.
2. Highlight the information that you want to chart. Click the first cell in the series that you want to highlight. While holding down the mouse button, drag the cursor highlighting all the data that will be inserted in chart.
3. Choose the type of chart you want to create. Click the Line button. This button is located under the Insert tab on the top ribbon. Choose the first option labeled 2D line.
4. Format the chart by adding a chart title, axis titles and legend. These labels assist the reader with identifying the data being represented. These options can be found under the Layout tab. The Design tab contains an option to switch the data on the X and Y axes and to select additional data cells. Another way to accomplish this is by right-clicking on the chart and selecting change data.
5. Enhance the visual appearance of your chart by using the Design and Format tabs. The Design tab has chart layouts for quick customization. You can also manually personalize your chart. The line color can be changed under the Design tab. The Format tab has options to apply text effects, shape effects and colored borders.
6. Move the chart to a separate worksheet. The chart will be embedded in the worksheet that contains the data upon creation. Select the chart and click on the Design tab. Click the last button named Move Chart. You will then have the option of moving the selected chart to a new worksheet.