Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Make a Single Line Graph in Excel (A Short Way)

In this article, you’ll learn how to make a single line graph in Excel and some other tips related to Excel charting.

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.

So, let’s get started with a simple example to demonstrate how to create a line chart and the type of data that can be showcased effectively, using a line chart.


A social media marketer is evaluating the number of videos his company has uploaded to YouTube over a five year period. He decides to present the data using a line chart since years are equally spaced.

The source data is shown below.

How to make a single line graph in Excel Image 1

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

1) First things first, select the data needed as shown below.

How to make a single line graph in Excel Image 2

2) Go to Insert > Charts > click on the drop-down arrow next to Line Chart and select 2-D Line, Line as shown below.

Line Chart in Excel

Read More:How to Make a Pie Chart in Excel [Video Tutorial]

# Formatting the Line Graph

3) 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.

Change Chart Theme

4) Select the grid lines as shown below and press delete.

Create a line chart in Excel

Make a line graph in Excel

5) Select the Chart Title and type Number of YouTube Videos Uploaded Over the Five Year Period.

Make a line graph in Excel Image 3

6) Select the Chart Title and decrease the font size, by going to Home > Font and change the font size to 12.

Make a line graph in Excel Image 5

And there you have it, a line chart created in a few easy steps.

Download Working File



Line charts are used to showcase or display trends over time. The horizontal or category axis is equally spaced and equidistant. Line charts are quite simple to create, format and understand.

Please feel free to comment and tell us if you use line charts extensively in your spreadsheets.

Read More…

The Main Differences between a Bar Graph and a Histogram

How to Format a Pie Chart in Excel

Sparklines in Excel (Insert, Change, & Modify to Show Data Trends)!

How to Create Combination Charts with a Secondary Axis in Excel

Taryn N
Taryn is a Microsoft Certified Professional, who has used Office Applications such as Excel and Access extensively, in her interdisciplinary academic career and work experience. She has a background in biochemistry, Geographical Information Systems (GIS) and biofuels. She enjoys showcasing the functionality of Excel in various disciplines.

She has over ten years of experience using Excel and Access to create advanced integrated solutions.

We will be happy to hear your thoughts

      Leave a reply