Step 4: In the below window, click on Add. Step 3: Now right-click on the chart and choose the Select Data option. Step 2: After you click on Insert Chart, you will see an empty chart. Step 1: Place the cursor in the empty cell and click on the insert chart.
How to make a graph in excel how to#
Please feel free to comment and tell us if you use line charts extensively in your spreadsheets. Now I will show you how to build an excel chart with manual selection of the data. The formatting is important because you want to be able to add more data without having to re-arrange everything. Line charts are quite simple to create, format, and understand. To create a chart that will update automatically you need to set up a spreadsheet that can house the data you want to use. The horizontal or category axis is equally spaced and equidistant. Line charts are used to showcase or display trends over time. Read More: How to Make a Pie Chart in Excel [Video Tutorial # Formatting the Line Graphģ) With the Chart selected, go to Chart Tools > Design > Chart Styles and select Chart Style 2 as shown below, in order to quickly format the chart.Ĥ) Select the grid lines as shown below and press delete.ĥ) Select the Chart Title and type Number of YouTube Videos Uploaded Over the Five Year Period.Ħ) Select the Chart Title and decrease the font size, by going to Home > Font and change the font size to 12.Īnd there you have it, a line chart created in a few easy steps. Read More: How to Create a Combo Excel Chart How to Make a Single Line Graph in Excel (Step by Step) # Creating the Line Graphġ) First things first, select the data needed as shown below.Ģ) Go to Insert > Charts > click on the drop-down arrow next to Line Chart and select 2-D Line, Line as shown below. He decides to present the data using a line chart since years are equally spaced. A social media marketer is evaluating the number of videos his company has uploaded to YouTube over a five-year period.