A line chart is a type of graph that is a visual representation of the changes in data using an X axis and a Y axis. For example, a line graph could show a company's stock price over five years. You can create a line graph using the Microsoft Excel 2007 spreadsheet application. First, create a chart for your data in the spreadsheet of the application. Next, insert the style of line chart you want into the spreadsheet when your data chart is highlighted. You can then edit the line graph to meet your preferences using the Chart Tools feature that becomes available after you insert the new chart.
Instructions
1. Open the Microsoft Excel 2007 application on your computer and click on the "Microsoft Office" button. Click on the "Open" option.
2. Locate the file on your computer that contains the data you want to turn into a line graph. Select the file and then click on the "Open" button.
3. Click on the "Insert" tab and then click on the "Line" option from the "Charts" group. Click on the "Line with Markers" option.
4. Use your mouse to highlight the data within the spreadsheet that also contain labels for the rows and columns. The Chart Tools feature now becomes available.
5. Click on the "Design" tab and the select a line graph style from the "Chart Styles" group. Click on the "Layout" tab and then click on the "Chart Title" option. Click on the "Above Chart" option.
6. Click in the chart title text box and enter a title for your chart. Right-click on the chart title and enter a size for the chart title that meets your preference in the "Size" box.
7. Click on the "Layout" tab and then select a legend style for your line graph from the "Chart Elements" box. Click on the "Legend" the "Layout" tab and select the position for the legend, such as the "Show Legend at Top" option.
8. Click on the "Axis Titles" option from the "Layout" tab and enter titles for the X axis and Y axis of your line graph. You make any other changes to the line graph, such as thickness or color of lines, by clicking on the "Design" tab.
Tags: line graph, Excel 2007, chart title, line graph, option Click, option from, then click