Excel Tutorial Line Graph

How to make a line graph in excel.

Excel tutorial line graph. Excel offers a number of different variations of the line graph. Move your line graph. Line graphs are generally used to show trends of a series of data points. Follow the steps given below to insert a line chart in your worksheet.

In the following tutorial well show you how to create a single line graph in excel 2011 for mac. Here are the steps to follow in creating a line chart. The line graph is one of the simplest graphs you can make in excel. In this tutorial we will be discussing how to create a basic line graph on microsoft excel 2016.

Line charts can show continuous data over time on an evenly scaled axis. Use a line chart if you have text labels dates or a few numeric labels on the horizontal axis. Step 1 arrange the data in columns or. Line charts are used to display trends over time.

Learn the basics of excel charts to be able to quickly create graphs for your excel reports. Its a really simple process and you can turn any data into a nice looking line graph. The most effective visuals are often the simplestand line charts another name for the same graph are some of the easiest to understand. You can also move specific sections of the line graph eg the title by clicking and dragging them around within the line graphs window.

Written by co founder kasper langmann microsoft office specialist. It is typically used to show the behavior of a metric data set over time week months year. Creating a single line graph in excel is a straightforward process. Click and drag the white space near the top of the line graph to move it.

Use scatter with straight lines to show scientific xy data. In this video i show you how to make a line graph in excel. Therefore they are ideal for showing trends in data at equal intervals such as days months quarters or years.