Click to select Connect data points with line, and then Press OK twice. How do I create a graph that appears in an Excel cell after I click on that particular cell? To create a line chart, follow these steps: Select the data to include for your chart. On a Mac, Excel may just open to a blank workbook automatically depending on your settings. While line graphs are a great tool, they can be used to mislead in a couple different ways. Our world-class consulting team is here to help your organization realize the lasting advantage of Smartsheet. Can axis scales be customized rather than automatic? Next, go to the INSERT tab in the Ribbon, and click on the Line Chart icon to see the line … Right-click an axis (the new lines will appear perpendicular to the axis selected), and click Add Minor Gridlines or Add Major Gridlines (if available). For this, first, select the data table and then go to Insert menu, under Charts, select Insert Line Chart as shown below. How to make a line graph in Excel on your desktop Enter the data you want to present in a line graph. In Excel, an advanced chart can be created by using the basic charts which are already there in Excel, can be done from scratch, or using pre-made templates and add-ins. To conclude this article on Line Graph Maker, we can say that Rapid Tables, NCES, Meta-Chart, Online chart Tool, ChartGo, Canva, and Venngage are free for use. Learn how the flexible, extensible Smartsheet platform can help your organization achieve more. However, too much manipulation can be misleading. Other Versions of Excel: Click the Insert tab > Line Chart > Line. Line graphs provide an easy way to track trends. 100% Stacked Line: This graph is similar to a stacked line graph, but the Y axis depicts percentages rather than an absolute values. Line graph maker You're on the line graph maker page. Here are the steps to follow in creating a Line Chart: 1. Select the data. Highlight both columns of data and click Charts > Line > and make your selection. 1. You can change the scales of each axis to better illustrate the facts. The chart that describes data as points connected by straight lines is called as line graph or line chart. 2. With the left mouse click, select the data and click on Insert. Its spreadsheet application named SpreadForm One can create a variety of graphs including line graphs, area charts, bar charts, combination graph, pie chart, surface graph, etc. For example, tracking your budget over the year would have the date in the left column and an expense in the right. Select the range A1:D7. Stacked Line Chart; 100% Stacked Line Chart; The line chart series also includes three other styles that are identical to the above but add markers to each data point in the chart: How to Create a Line Chart. 2. However, the Y axis scale on the second graph starts at 15 rather than zero, so the decrease appears steeper on that line graph. You can add data to your graph by entering it in a new column, selecting and copying it, and then pasting it into the graph window. We know ads can be annoying, but they’re what allow us to make all of wikiHow available for free. Kasper Langmann, Co-founder of Spreadsheeto. In the Insert toolbar, there will be a section called Charts. Read on to learn how to create a line graph in Microsoft Excel, the main components, what they are and aren’t good for, how to read them, and how they can be misleading. This article has been viewed 1,389,955 times. As you may have seen throughout your various uses of Excel, the program is a great way to store and organize information. Organize data by learning how to make a line graph in Excel. The following options are available for most of the graph elements. Click on the ‘Insert’ tab, go to section ‘Charts’ and select the line graph option. A few definitions to clarify what’s in the paragraph above: A graph is a collection of vertices connected by edges. Highlight both columns of data and click Charts > Line > and make your selection. The wikiHow Tech Team also followed the article's instructions and verified that they work. If I have a data point that would be way off the graph, how can I insert an axis break to still show the point? % of people told us that this article helped them. 1. Stacked Line: This option requires more than one data set. ©2021. Get up and running fast with streamlined implementation and solution building to address your immediate business needs. To set the background color, (1) Click on the 'Axis' selector on the options menu on the left side of the plot, (2) Click on the 'Lines' tab from the pop-up, (3) Set 'Background' to 'On', and (4) Select background color from the color pallete. wikiHow is where trusted research and expert knowledge come together. Learn about our premium resource and portfolio management platform, 10,000ft by Smartsheet. In the "Charts" section of the Insert toolbar, click the visual representation of the type of graph that you want to use. The line graph (also called line chart) is used to display the data graphically that change over the period of time. If multiple lines are present in my chart, how can I view one at a time? The following two graphs show the same data. He is technology enthusiast and an English teacher. The Line option adds a border around the text. Therefore, the lines will never cross. In many cases, the way the data is trending makes it easy to predict the results of data in yet-to-be-recorded time periods. To print graph, … You can add more lines to the plot area to show more granularity. To adjust the spacing between gridlines, right-click and then click Format Major Gridlines or Format Minor Gridlines. See the beginning of this section for the other options. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d1\/Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-5.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-5.jpg","bigUrl":"\/images\/thumb\/d\/d1\/Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-5.jpg\/aid1146296-v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-5.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"

License: Fair Use<\/a> (screenshot)

\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0d\/Make-a-Line-Graph-in-Microsoft-Excel-Step-3-Version-5.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-3-Version-5.jpg","bigUrl":"\/images\/thumb\/0\/0d\/Make-a-Line-Graph-in-Microsoft-Excel-Step-3-Version-5.jpg\/aid1146296-v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-3-Version-5.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"

License: Fair Use<\/a> (screenshot)

\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/46\/Make-a-Line-Graph-in-Microsoft-Excel-Step-4-Version-5.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-4-Version-5.jpg","bigUrl":"\/images\/thumb\/4\/46\/Make-a-Line-Graph-in-Microsoft-Excel-Step-4-Version-5.jpg\/aid1146296-v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-4-Version-5.jpg","smallWidth":460,"smallHeight":349,"bigWidth":728,"bigHeight":552,"licensing":"

License: Fair Use<\/a> (screenshot)

\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5d\/Make-a-Line-Graph-in-Microsoft-Excel-Step-5-Version-4.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-5-Version-4.jpg","bigUrl":"\/images\/thumb\/5\/5d\/Make-a-Line-Graph-in-Microsoft-Excel-Step-5-Version-4.jpg\/aid1146296-v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-5-Version-4.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"

License: Fair Use<\/a> (screenshot)

\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/16\/Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-5.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-5.jpg","bigUrl":"\/images\/thumb\/1\/16\/Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-5.jpg\/aid1146296-v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-5.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"

License: Fair Use<\/a> (screenshot)

\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d7\/Make-a-Line-Graph-in-Microsoft-Excel-Step-7-Version-5.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-7-Version-5.jpg","bigUrl":"\/images\/thumb\/d\/d7\/Make-a-Line-Graph-in-Microsoft-Excel-Step-7-Version-5.jpg\/aid1146296-v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-7-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)

\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/60\/Make-a-Line-Graph-in-Microsoft-Excel-Step-8-Version-5.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-8-Version-5.jpg","bigUrl":"\/images\/thumb\/6\/60\/Make-a-Line-Graph-in-Microsoft-Excel-Step-8-Version-5.jpg\/aid1146296-v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-8-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)

\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ef\/Make-a-Line-Graph-in-Microsoft-Excel-Step-9-Version-5.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-9-Version-5.jpg","bigUrl":"\/images\/thumb\/e\/ef\/Make-a-Line-Graph-in-Microsoft-Excel-Step-9-Version-5.jpg\/aid1146296-v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-9-Version-5.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"

License: Fair Use<\/a> (screenshot)

\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a7\/Make-a-Line-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg","bigUrl":"\/images\/thumb\/a\/a7\/Make-a-Line-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg\/aid1146296-v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"

License: Fair Use<\/a> (screenshot)

\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/97\/Make-a-Line-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg","bigUrl":"\/images\/thumb\/9\/97\/Make-a-Line-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg\/aid1146296-v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"

License: Fair Use<\/a> (screenshot)

\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/39\/Make-a-Line-Graph-in-Microsoft-Excel-Step-12-Version-2.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-12-Version-2.jpg","bigUrl":"\/images\/thumb\/3\/39\/Make-a-Line-Graph-in-Microsoft-Excel-Step-12-Version-2.jpg\/aid1146296-v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":542,"licensing":"

License: Fair Use<\/a> (screenshot)

\n<\/p><\/div>"}, How to Make a Line Graph in Microsoft Excel, hacer un gráfico lineal en Microsoft Excel, Ein Liniendiagramm in Microsoft Excel erstellen, построить линейный график в Microsoft Excel, Jak vytvořit spojnicový graf v Microsoft Excel, Membuat Grafik Garis pada Microsoft Excel, माइक्रोसॉफ्ट एक्सेल में लाइन ग्राफ बनायें, Microsoft Excel'de Çizgi Grafiği Nasıl Yapılır, consider supporting our work with a contribution to wikiHow.