You are viewing the article How to Create a Line Chart in Microsoft Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 34,578 times.
In this article, the wikiHow will show you how to create a line chart from Microsoft Excel data. You can apply this method to both Windows and Mac Excel programs.
Steps
Create a line chart
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d1/Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-5.jpg/v4- 728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d1/ Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-5.jpg/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-5. jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the Microsoft Excel program. Double-click the Excel program icon, which looks like a white X on a green folder. This will open the excel home page.
- If you already have an Excel spreadsheet with pre-imported data, double-click it and skip the next two steps.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0b/Make-a-Line-Graph-in-Microsoft-Excel-Step-2-Version-5.jpg/v4- 728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-2-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0b/ Make-a-Line-Graph-in-Microsoft-Excel-Step-2-Version-5.jpg/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-2-Version-5. jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output”></div>”}
Click on Blank Workbook . This button is located on the home page of Excel. This opens a new spreadsheet for your data.
- For Macs, Excel can only open blank spreadsheets automatically if installed. If the blank workbook is opened automatically, skip this step.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0d/Make-a-Line-Graph-in-Microsoft-Excel-Step-3-Version-5.jpg/v4- 728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-3-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0d/ Make-a-Line-Graph-in-Microsoft-Excel-Step-3-Version-5.jpg/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-3-Version-5. jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”<div class=”mw-parser-output”></div>”}
Insert information. Line charts require two axes. Enter data in two columns. For ease of use, put the X-axis (time) data in the left column, and the right column is your recorded observation.
- For example, a table that tracks your budget for this year will have a date column on the left and an expense column on the right.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/46/Make-a-Line-Graph-in-Microsoft-Excel-Step-4-Version-5.jpg/v4- 728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-4-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/46/ Make-a-Line-Graph-in-Microsoft-Excel-Step-4-Version-5.jpg/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-4-Version-5. jpg”,”smallWidth”:460,”smallHeight”:349,”bigWidth”:728,”bigHeight”:552,”licensing”:”<div class=”mw-parser-output”></div>”}
Select data. Click and drag your mouse from the top left cell in the data group to the bottom right cell in the data group. This will highlight all your data.
- Be sure to include the headers of the columns in the data table, if available.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5d/Make-a-Line-Graph-in-Microsoft-Excel-Step-5-Version-4.jpg/v4- 728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-5-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5d/ Make-a-Line-Graph-in-Microsoft-Excel-Step-5-Version-4.jpg/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-5-Version-4. jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser-output”></div>”}
Click on the Insert tab. This tab is located on the left side of the green ribbon at the top of the Excel window. The Insert toolbar will open below the blue ribbon.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/16/Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-5.jpg/v4- 728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/16/ Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-5.jpg/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-5. jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:541,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the “Line Graph” icon. It’s the box with multiple lines in the Charts option group. Then there will be a drop-down menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d7/Make-a-Line-Graph-in-Microsoft-Excel-Step-7-Version-5.jpg/v4- 728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-7-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d7/ Make-a-Line-Graph-in-Microsoft-Excel-Step-7-Version-5.jpg/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-7-Version-5. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select a chart type. Hover your mouse pointer over the graph template in the drop-down menu to see how it looks with your data. You will see a graph window pop up in the middle of the Excel window.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/60/Make-a-Line-Graph-in-Microsoft-Excel-Step-8-Version-5.jpg/v4- 728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-8-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/60/ Make-a-Line-Graph-in-Microsoft-Excel-Step-8-Version-5.jpg/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-8-Version-5. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the graph type. Once you’ve selected a chart style, click on it to create a line chart in the center of the Excel window.
Graph editing
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ef/Make-a-Line-Graph-in-Microsoft-Excel-Step-9-Version-5.jpg/v4- 728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-9-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ef/ Make-a-Line-Graph-in-Microsoft-Excel-Step-9-Version-5.jpg/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-9-Version-5. jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser-output”></div>”}
Customize the design of the chart. Once the graph has been created, the Design toolbar will be opened. You can change the design and look of your chart by clicking on one of the variations in the “Chart Styles” section of the toolbar.
- If this toolbar is not open, click on your chart and then click the Design tab in the green ribbon.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a7/Make-a-Line-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg/v4- 728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a7/ Make-a-Line-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-10-Version-2. jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser-output”></div>”}
Move line chart. Click and drag the space near the top of the line chart to move it.
- You can also move specific parts of the line chart (for example, the title) by clicking and dragging them around in the line chart window.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/97/Make-a-Line-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg/v4- 728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/97/ Make-a-Line-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-11-Version-2. jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:548,”licensing”:”<div class=”mw-parser-output”></div>”}
Adjust the graph size. Click one of the circles at the edges or corners of the chart window and drag out or in to zoom out or zoom in on your chart.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/39/Make-a-Line-Graph-in-Microsoft-Excel-Step-12-Version-2.jpg/v4- 728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-12-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/39/ Make-a-Line-Graph-in-Microsoft-Excel-Step-12-Version-2.jpg/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-12-Version-2. jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:542,”licensing”:”<div class=”mw-parser-output”></div>”}
Change the title of the chart. Double-click the title, then select the “Chart Title” text and enter your chart’s name. Click anywhere in the chart’s name box to save the text.
- You can do the same to name the axis of the graph.
Benefits
- You can add data to a chart by entering data in a new column, selecting and copying that column, and then pasting it into the graph window.
Warning
- Some graphs are designed for a specific set of data (for example, percentages or currencies). Make sure your selected template has no theme before creating the chart.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 34,578 times.
In this article, the wikiHow will show you how to create a line chart from Microsoft Excel data. You can apply this method to both Windows and Mac Excel programs.
Thank you for reading this post How to Create a Line Chart in Microsoft Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: