Thursday, April 25, 2013

How to Graph a Line Graph in Excel 2007


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 Excel 2007 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' option from 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.

Blogger news