Microsoft Excel 2010 Line Graph Tutorial

Click and drag the white space near the top of the line graph to move it.

Microsoft excel 2010 line graph tutorial. Microsoft graph tutorials are step by step training exercises that guide you through creating a basic application that accesses data via the microsoft graph. This tutorial covers the basics of creating and formatting a column chart in excel 2010. I used excel 2010 in this tutorial but these instructions will apply to excel 2007 as well. In this video i show you how to make a line graph in excel.

Its a really simple process and you can turn any data into a nice looking line graph. Click on the row of data you wish to include in the line chart. You can also move specific sections of the line graph eg the title by clicking and dragging them around within the line graphs window. The video also shows how to print charts with or without worksheet.

You can make a graph in excel 2010 to increase the efficacy of your reports. Microsoft excel is available on both pcs and macs so what you learn in class today should be. Below is a screenshot to present how a graph looks like in ms excel 2010 worksheet. Gathering data.

Move your line graph. Microsoft excels spreadsheets work intuitively forming charts and graphs from selected data. Microsoft office 2010 getting started page 02 prerequisites what you will learn. Charts group is one of the most useful groups of microsoft excel 2010 and it has been improved and came around with some new features which were not available with the excel 2007.

Use a line chart if you have text labels dates or a few numeric labels on the horizontal axis. Click on the insert tab in the office ribbon. To create a line chart execute the following steps. Download excel spreadsheet of microsoft stock prices msft stocks line graph.

Use a scatter plot xy chart to show scientific xy data. Select the range a1d7. In this updated tutorial for excel 2010 users learn how to create a simple spreadsheet in excel 2010 also applies to excel 2007 excel 2013 complete with. Create a line chart in excel.