How to Make a Line Chart in Excel: 12 Steps (with Pictures)

Table of contents:

How to Make a Line Chart in Excel: 12 Steps (with Pictures)
How to Make a Line Chart in Excel: 12 Steps (with Pictures)
Anonim

In this article you can read how to create a line chart with data in Excel. This can be done on a PC with Windows as well as on a Mac.

Steps

Part 1 of 2: Creating a line chart

Make a Line Graph in Microsoft Excel Step 1

Step 1. Open Excel

Click twice on the Excel icon. It looks like a white letter 'X' on a green folder. This is how you open the Excel home page.

If you already have an Excel file with data, click on the file and skip the two steps below

Make a Line Graph in Microsoft Excel Step 2

Step #2. Click on Blank Worksheet

You can find this option on the Excel home page. This is how you open a new worksheet in Excel for your data.

On a Mac, depending on your settings, you may automatically see a blank worksheet. If so, skip this step

Make a Line Graph in Microsoft Excel Step 3

Step 3. Enter your details

A line chart must consist of two axes. Enter your details in two columns. For convenience, put the X-axis (time) data in the left column and the data you collected in the right column.

For example, if you want to see how much you have spent during a year, put that date in the left column and your expenses in the right column

Make a Line Graph in Microsoft Excel Step 4

Step 4. Select your data

Click on the cell at the top left and drag your mouse to the bottom right cell of the data group. This way you select all your data.

Don't forget to also select the column headings, if applicable

Make a Line Graph in Microsoft Excel Step 5

Step 5. Click the Insert tab

You can find it to the left of the green ribbon at the top of the Excel window. How to open the taskbar Insert under the green ribbon.

Make a Line Graph in Microsoft Excel Step 6

Step 6. Click on the 'Line Chart' icon

It is the box with several lines drawn on it in group with options for Diagrams. A drop-down menu will then appear.

Make a Line Graph in Microsoft Excel Step 7

Step 7. Choose a style for your diagram

Swipe your mouse cursor over one of the sample charts you see in the drop-down menu to see what a particular menu would look like with your data. You should see a window with a graph on it appear in the middle of your Excel window.

Make a Line Graph in Microsoft Excel Step 8

Step 8. Click on a type of chart

Once you have chosen a model, you can create your line chart by clicking on it. It will appear in the middle of the Excel window.

Part 2 of 2: Editing your chart

Make a Line Graph in Microsoft Excel Step 9

Step 1. Edit your chart design

Once you have created your chart, a toolbar will appear with the title Design. You can edit the design and look of your chart by clicking one of the variations in the Chart Styles section of the toolbar.

  • If this toolbar does not open, click on your chart and then click on the tab To design in the green ribbon.
Make a Line Graph in Microsoft Excel Step 10

Step 2. Move your line chart

Click on the white space almost at the very top of the line chart and drag the chart to where you want it.

You can also move specific parts of the line chart (for example, the title) by clicking and dragging them around within the line chart window

Make a Line Graph in Microsoft Excel Step 11

Step 3. Make the chart bigger or smaller

Click on one of the circles on one of the corners of the graph window and drag it in or out to make the graph larger or smaller.

Make a Line Graph in Microsoft Excel Step 12

Step 4. Adjust the title of the chart

Click twice on the chart title, then select the text 'Chart Name' and type in the title of your chart. Save the text by clicking anywhere outside the chart name field.

You can also do this with the chart axes titles

Tips

Popular by topic