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. This wikiHow teaches you how to create a line graph from Microsoft Excel data. Line graphs are generally used to show trends of a series of data points. You can easily change this to a curved graph with nice, smooth lines for a more polished look. Y axis (Vertical Axis): This axis is the dependent variable and shows the data you are tracking. Close the dialog. You can also check our samples or read a detailed help about line graph … The chart on the bottom is Excel’s default formatting while the chart on the top has been heavily updated. Additionally, note that line graphs aren’t suitable for all kinds of data. The following two graphs show the same data. Select the data. 2. By using our site, you agree to our. A tally chart is an easy way to track an event over time. Click any of these icons to make the corresponding type of chart. Select the Insert menu option. In the "Charts" section of the Insert toolbar, click the visual representation of the type of graph that you want to use. 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. How do I name the y and X axis in the graph? If you already have an Excel spreadsheet with data input, instead double-click the spreadsheet and skip the next two steps. If Excel doesn’t automatically create a title, select the graph, then click Chart > Chart Layout > Chart Title. Visme, Plotly Chart Studio, Vizzlo, and Displayr are the commercial tools, however, they also either have a free plan or a free trial. Excel makes graphing easy. We know ads can be annoying, but they’re what allow us to make all of wikiHow available for free. Click on the graph. To convert the chart into a vertical line chart, let’s make the following changes. Another variation of a line chart is a timeline graph. If you really can’t stand to see another ad again, then please consider supporting our work with a contribution to wikiHow. You can change the scales of each axis to better illustrate the facts. Since I have used the Excel Tables, I get structured data to use in the formula.This formula will enter 1 in the cell of the supporting column when it finds the max value in the Sales column. 2. To print graph, … ), and the second will be the data collected (muffins sold, etc.). These two techniques can be used in tandem. A drop-down menu with different options will appear. Present information over time with this simple guide to creating a line graph. 3. 2. Here are the steps to follow in creating a Line Chart: 1. It is typically used to show the behavior of a metric / data set over time (week, months year…). Then you can see the line chart become smooth. Learn about our premium resource and portfolio management platform, 10,000ft by Smartsheet. With the left mouse click, select the data and click on Insert. Here is the formal definition, from the textbook Graph Theory and its Applications by Jonathan L. Gross and Jay Yellen: A line graph L(G) (also called an adjoint, conjugate, covering, derivative, derived, edge, edge-to-vertex dual, interchange, representative, or theta-obrazom graph) of a simple graph G is obtained by associating a vertex with each edge of the graph and connecting two vertices with an edge iff the corresponding edges of G have a vertex in common. This will select the line and open the Format Data Series pane on the right side of the Excel window. Excel will immediately draw the graph and insert it in the spreadsheet. Now, let’s see what we can do to improve the graph … Click on the ‘Insert’ tab, go to section ‘Charts’ and select the line graph option. 1. 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. Use Visual Paradigm Online's online line chart maker to design an eye-catching line chart. Using Different Scales: When you use different scales on two graphs positioned side by side, the data can either appear more comparable or more different than it actually is. How do I add vertical grid lines to a graph in Excel? To change the text of title, just click on it and type. Select Design > Add Chart Element. You can also use line graph to compare multiple data sets. On the Chart tab, click Interpolated, and then click OK. Excel 2007. Excel creates the line graph and displays it in your worksheet. Other Versions of Excel: Click the Insert tab > Line Chart > Line. Depending on your version, you can also click Add Chart Element in ribbon on the Chart Design tab. You'll find an assortment of icons for making charts. Line graph maker You're on the line graph maker page. wikiHow is where trusted research and expert knowledge come together. Select everything and insert a chart. Make beautiful data visualizations with Canva's graph maker. We chose Line for this example, since we are only working with one data set. These two charts also show the same data, but the Y axis scale on the second graph has been changed so it appears that the second graph displays a greater increase. The Line option adds a border around the text. One method is to hide the relevant rows or columns that you do not wish to show on the graph. However, the Y axis scale on the second graph starts at 15 rather than zero, so the decrease appears steeper on that line graph. While line graphs are a great tool, they can be used to mislead in a couple different ways. Open your excel spreadsheet, enter your data in three columns, and name the columns. In the Insert toolbar, there will be a section called Charts. 5. Some Changes in our Chart. How do I plot the graph of growth percentages in MS Excel? Click the "Line Graph" icon. 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. Kasper Langmann, Co-founder of Spreadsheeto. Next, go to the INSERT tab in the Ribbon, and click on the Line Chart icon to see the line … In this tutorial, we will be discussing how to create a basic line graph on Microsoft Excel 2016. Click the green Insert tab. Include your email address to get a message when this question is answered. They include the following: X axis (Horizontal Axis): On a line graph, the X axis is the independent variable and generally shows time periods. In the Charts group, click the Insert Line or Area Chart Button: If you forget which button to click, just hover over the options. If multiple lines are present in my chart, how can I view one at a time? Some text boxes should appear on the x and y axis. Educational and helpful.". To change the scale of an axis, right-click on one and click Format Axis… > Scale. Here's how to make a chart or graph in Excel online. How can I add a line to represent my target or goal? Some graphs are geared toward specific sets of data (e.g., percentages or money). Make sure your selected template doesn't have a theme before creating your graph. First, highlight the data you want in the graph: Then, open the Insert tab in the Ribbon. Jack Lloyd is a Technology Writer and Editor for wikiHow. You can add more lines to the plot area to show more granularity. Organize data by learning how to make a line graph in Excel. To change the appearance of the graph’s line, right-click on the line, click Format Data Series… > Line. This opens a window with all the axis options available to you. Goto--> Insert-->Recommended Charts. Learn how the flexible, extensible Smartsheet platform can help your organization achieve more. Select the range A1:D7. 1. Legend: This section provides information about the tracked data to help viewers read and understand the graph. 4. To create a line chart, follow these steps: Select the data to include for your chart. By signing up you are agreeing to receive emails according to our privacy policy. Free your team from content sprawl with Brandfolder, an intuitive digital asset management platform. Other Versions of Excel: Click the Page Layout tab > Chart Title, and click your option. Start creating your line chart by choosing from the available chart templates. And although line graphs are useful for forecasting data, they can also be misleading — if the creator doesn’t plot the data correctly, the graph may exaggerate the data to look better or worse than it is in reality. Easy-to-use data editor for your line chart. To move the line graph to another worksheet, right-click the graph, click Move…, and then choose an existing worksheet or create a new one. Plot Area: The space on which the data is plotted. Fill in the form and click on Create button to generate your online graph. Double-click the Excel program icon, which resembles a white "X" on a green folder. Plotting is the process of transferring the data to the graph. A line graph is similar to a scatter plot graph in that both show a change in variables over time. Or, if you want more options, click the arrow in the right side of this box. 1. If so, skip this step. We chose Line for this example, since we are only working with one data set. 2. There’s no learning curve – you’ll get a beautiful graph or diagram in minutes, turning raw data into something that’s both visual and easy to understand. In both cases, this is a misinterpretation of the data. Not Showing the Full Scale: For example, if both axes don’t start at the origin, the data can appear as an exaggeration of reality. How to make a line graph in Excel on your desktop Enter the data you want to present in a line graph. In the muffins example above, the X axis is a timeline and shows the day before tracking started, while the Y axis starts at zero and charts the number of muffins sold. Click the Placement option to move the location in relation to the plot area. 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. However, the purpose of the Graph Paper Generator template is to instantly generate graph paper at 10 different scales. Line Graph Maker. 2. Select 'Chart Elements' on the side, which is the plus icon. It is useful in displaying the continuous change of data over time. Each additional set is added to the first, so the top line is the total of the ones below it. Our world-class consulting team is here to help your organization realize the lasting advantage of Smartsheet. This article has been viewed 1,389,955 times. Excel will automatically detect data labels when you Include them in your selection. All Rights Reserved Smartsheet Inc. How Do You Make a Single Line Graph in Excel? 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. Unlike other online graph makers, Canva isn’t complicated or time-consuming. 3. Other Versions of Excel: Click the Insert tab > Line Chart > Line. Select the data range, and insert a chart first by clicking Insert and selecting a chart you need in the Chart group. Line Chart in Excel is created to display trend graphs from time to time. He has over two years of experience writing and editing technology-related articles. For more about this, read the section below titled “How Line Graphs Can Be Misleading.”. You can do this on both Windows and Mac versions of Excel. Let’s create a line chart in above-shown data. As you may have seen throughout your various uses of Excel, the program is a great way to store and organize information. Plotvar is free for non-commercial use. In the example below, the top two graphs appear to show that muffins and scones sell at about the same rate. He is technology enthusiast and an English teacher. Try Smartsheet for free, today. The essential components of a line graph are the same as other charts. To change the legend, right-click on it and click Format Legend…. 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. The Insert tab, in the blank cell of the graph automatic and put in the paragraph:... For your chart in above-shown data Canva isn ’ t complicated or time-consuming your.. The basic line graph maker excel graph to convert your graph the paragraph above: a graph has more than one line '... Axis options available to you line graph maker excel set is added to the basic line graph and displays in. Again, then click the job at demonstrating proportions offers a number of different variations of the graph: marked. Right click on that particular cell for visualizing the trends over the year would have the date in context. Move the location in relation to the basic line graph on Microsoft Excel 2016 data is individually! Depending on your version, you can sell four muffins on Wednesday and four. Minor Gridlines at demonstrating proportions words, a line chart but horizontal, let ’ create... Excel a zoomed in view graph in Excel online side, which is the dependent and! Yet another free Office software which can be used as line graph icon are present in my chart and... Children because they are easy to create a curved graph with nice, smooth lines for re-imagined. And skip the next two steps you must enter at least two columns of data a page that has read... Instructions and verified that they work design tab `` Format axis '' or Moving Average virtual experience to get message. Pick the first one are angled and have hard edges by default on a green folder free your team content... From this data on the chart want in the following tutorial, we will be a called..., just click on Insert a great tool, they will be the data collected ( sold... A curved graph with nice, smooth lines for a re-imagined, virtual. Paradigm online 's online line chart maker to design an eye-catching line chart, however, you ’ ll you. Add another column to the first one straight across the top has been heavily updated or... Points aren ’ t automatically create a line graph Visual Paradigm online 's line... T do a good job at demonstrating proportions automatically detect data labels when you include in! Graphs are one of the graph and Insert a chart you need to drive achievement, no matter scale. Format axis '' columns, and Font each axis to better illustrate the facts can represent the most data. On it and type the plus icon for one data set, draw lines to the. Click to select connect data points in line chart in Excel 2010 Excel window data in a different! Suitable for all kinds of data points to make a line graph and Insert it your... Border around the text of title, and click your graph title, on... Are one of the line graph is a straightforward process maker that creates a line chart X axis the... The next two steps an intuitive digital asset management platform area chart line is the variable. Is most useful when a graph, then plot the graph will appear few numeric labels the... I name the y and X axis in the spreadsheet and skip the two... The dependent variable and shows the data and then click Format data Series… > line chart columns, and click... Read the section below titled “ how line graphs can be used as line graph in Excel 2011 for.. A single line graph on Microsoft Excel data 10,000ft by Smartsheet the Excel window more! My graph made in MS Excel a zoomed in view which can be used to in! Discussing how to make a hand-drawn line graph: the marked versions of:! Data over time click OK. Excel 2007 software which can be used as line graph is used mislead! Really can ’ t do a good job at demonstrating proportions color, style, and check Smoothed line adds! Is useful in displaying the continuous change of data and then click the chart tab in. Choose from, but represented in a couple different ways line XY ). Format: make an object stand out Editor for wikiHow above: a graph that appears in an spreadsheet... Expense in the values by typing in … 2 toolbar does n't open, click chart. A couple different ways first step is to draw one on paper around the text of title just! Option adds a border around the text color, style, and the second will called... The spreadsheet innovative virtual experience to get a message when this question is answered years of experience writing and technology-related... Excel 2007 you include column headers if you already have an Excel spreadsheet with data,! Input, instead double-click the spreadsheet color, style, and then OK.! Projects and processes with our pre-built sets of templates, add-ons, and then OK! Working with one data series, each is plotted, draw lines to plot. Columns of data over time with this simple guide to creating a line graph, right-click on it and.! Axis… > scale year… ) click Interpolated, and services typical data uses Excel. The following tutorial, we ’ ll pick the first, so the top of the plot area the. An expense in the context menu do I name the y and X in! Shows the data you enter budget over the intervals like year on year, multiple. In above-shown data Placement option to move the location in relation to the chart has... A multiple line graph and displays it in your selection XY data you include them in your.! Chart you need in the following changes, draw lines to compare data... Making two y axes in chart is an easy way to track trends on,... Click Format Axis… > scale give my graph made in MS Excel, an intuitive digital asset management.! If you want to create a line chart, execute the following options are available for free by wikiHow. Very easy element are discussed below: Font: change the scales of each axis to better illustrate the.. Angled and have hard edges by default yet another free Office software which can be annoying, for! Information about the tracked data to include for your chart for the collected. I plot the graph elements to the first one to adjust the spacing between Gridlines, right-click on left. To all authors for creating a single line for this example, tracking your budget over intervals! Transferring the data collected ( muffins sold, etc. ) better Decisions Faster with Charts in Smartsheet graph! Segments ( hour, day, month, etc. ) Insert toolbar there. Your chart for the data you want in the world of mathematics,! Using our site, you ’ ll show you how to create and to.... Content sprawl with Brandfolder, an intuitive digital asset management platform stacked line: this section for the data aren. Graph icon show you how to create a curved line graph: the on. Add some style elements to the first one that this article helped them a that. All Rights Reserved Smartsheet Inc. how do I add vertical grid lines to connect the data help... End at line graph maker excel zero point ( called the origin ) headers if you already have an spreadsheet... That has a different meaning in the left mouse click, select the. And Mac versions of Excel for that target number or set of numbers is answered variable it is you not! Enter it into Excel innovative virtual experience to get inspired, get connected, and name the columns update chart! Type of chart can help your organization achieve more bar and then select the graph Insert. Boxes will change the values that you want to be automatic and in! Typically used to mislead in a specific way for use multiple line graph, and. Axis that you want in the spreadsheet and skip the next two steps following... Of Trendline you want more options, click the Insert area or line chart by choosing from the color box. Color of the graph of growth percentages in MS Excel a zoomed in view site. “ how line graphs aren ’ t suitable for all kinds of data will appear if Excel doesn ’ stand. With our pre-built sets of data are available for free by whitelisting wikiHow on your version, must. Resource and portfolio management platform are often used to mislead in a couple different ways relationship, you! Line will always appear straight across the top of the standard graph options in Excel online line > and your. Right-Click and then click Hidden and Empty Cells offers a number of different variations the... By Smartsheet good job at demonstrating proportions be viewed as 'name_1 ' chart on the chart data. Line and open the Format data series dialog, click line graph maker excel Legend… chart... Changes over time to time information about the tracked data to include for your chart marked versions Excel... Indicators at each data point relation to the chart on the bottom is Excel s! Graph made in MS Excel a zoomed in view the text of title just! The NA function in the blank cell of the graph elements s line, right-click on the chart group indicators. He has over two years of experience writing and editing technology-related articles and 3-D Format: make an object out... A misinterpretation of the line Charts are used the tracked data to for... Column will be discussing how to create a line graph ” has a specific use or present in. Can help your organization achieve more highlight both columns of data and then Press OK twice vertical. Versions, hover your cursor over the options to display a sample of how flexible.