How Do You Make A Line Chart In Excel 2007?
Line charts allow data to be expressed visually for the purpose of showing trends over time. The horizontal axis or X axis displays category data, and the vertical or Y axis displays values. A line chart displays data by plotting it in relation to the X and Y axes. Microsoft Excel 2007 allows the creation of seven types of line charts, including 3D line charts. 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. 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. 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. Format the chart by adding a char
