One of the most common uses of Excel is to make a single line graph based on given data. It’s very useful while analyzing different data and trendlines. In this article, we will learn how to make a single line graph in excel.
What Is a Single Line Graph?
First, we need to know what a single line graph is. Suppose we have data on sales of any particular store of different products. So, if we want to visualize this data or the price of different products, we can simply plot the data and connect the line. This line is the single line graph in excel.
Line charts are useful for showcasing trends over time, while they may look similar in some ways to x-y scatter plots, the main difference with line charts is that the horizontal axis is an equally spaced category axis.
Download the Excel Workbook
You can download the practice workbook from here.
Types of Lines for Single Line Graph in Excel
There are different kinds of single line graphs in excel. Each of the line types signifies different visualization. All of them are shown below.
- Smooth Line Graph with Marker: In this type, we will get a rounded edge smooth line with small circles on the line pointing to the data that we have given in making the single line graph.
- Smooth Line Graph without Marker: This type of line is the same as the smooth line as the previous one, but it does not contain circular dots.
- Straight Line Graph: This type of line graph is a combination of small straight lines between two points. This type of line also contains 2 choices such as- with marker, and without marker. So, the with marker one contains the small dots pointing at graph data while without marker one does not. Below is an image of a straight line graph with markers.
Also, an example of straight line graph without markers is attached.
Procedure to Make a Single Line Graph in Excel
The steps to make a single line diagram in excel are very easy. The steps are below.
🔶 Step 1: Select Data
- First, select the columns based on which we will make a single line graph. For example, here we will use the Month and Price column.
Read More: How to Make a Line Graph in Excel with Two Sets of Data
🔶 Step 2: Choose a Suitable Line Graph from Charts Group of Insert Tab
- Second, we will go to the Insert tab in the Ribbon.
- Third, in the Insert tab, select any of the Scatter Plots in the Chart section.
As a result, this will give us a single line graph like the image below.
Read More: How to Make Line Graph in Excel with 2 Variables (With Quick Steps)
Similar Readings
- How to Draw Target Line in Excel Graph (with Easy Steps)
- Sparklines in Excel (A Clear Overview)
- How to Make a Line Graph in Excel with Multiple Lines (4 Easy Ways)
- How to Draw a Horizontal Line in Excel Graph (2 Easy Ways)
How to Format a Single Line Graph of Excel
After adding a single line graph, we can adjust or edit the single line graph for better understanding of the line and analysis. So, the possible editing of a single line graph in Excel are shown below.
i. Adding or Deleting Lines
We can add multiple lines and also delete lines from a single line graph. So, to add more lines, we can just select more data columns and plot from the beginning, following the process mentioned above.
Again, to delete a line, select any line in the plot and then press Delete on the keyboard or right click on it and then select delete.
Read More: How to Add a Vertical Dotted Line in Excel Graph (3 Easy Methods)
ii. Adding Trendline
For forecasting data, we can add a trendline to our plot. Let’s say we have this single line graph that shows different products and their demand.
We can forecast the demand of the product based on the given data and demand. First, we will click on the (+) button beside the graph and tick the Trendline option. As a result, it will instantly add a linear trendline to our existing single line graph.
Read More: How to Add a Marker Line in Excel Graph (3 Suitable Examples)
iii. Changing Line Type
Suppose we want to change the line type. So, if we have a smooth line with markers, and we want a straight line graph. So, we will simply select the graph> go to Insert tab > in the Chart area select Scatter plot > then different line type.
Read More: How to Make a Double Line Graph in Excel (3 Easy Ways)
How to Make a Line Graph in Excel with 3 Variables
Usually, we plot data based on a single variable that says the independent variable in the X axis and the dependent variable in the Y axis. But for 3 different variables, we will get 3 different lines. So, to get such a plot, we will select the independent data column and other 3 columns and follow the exact same procedures described above for 3 variables as well. As a result, we will get 3 lines for 3 variables like the below image.
Read More:Â How to Make a Line Graph in Excel with Multiple Variables
Thing to Remember
- Firstly, while selecting the columns for a single line graph, we need to be careful about the data type of those cells. If the independent value is not numeric, we will not be able to plot a single line diagram.
- The amount of data in each column should be the same, otherwise the missing data will not be shown, and Excel will automatically adjust the graph based on previous and next data.
- Finally, if your columns have headers, excel will automatically detect it and place it in the axis name.
Conclusion
That was the easiest way to make a single line graph in Excel. If you still need help with any of these methods, let us know in the comments. Our team is ready to answer all your questions. For any excel-related problems, you can visit our website Exceldemy for solutions.