How to Make a Line Graph in Excel

Tracking changes over time is fundamental to understanding your business, and a line graph is one of the most effective ways to visualize that data. Whether you're monitoring website traffic, monthly sales figures, or ad campaign performance, a well-made line graph makes trends and patterns instantly obvious. This guide will walk you through creating, customizing, and mastering line graphs in Microsoft Excel, step by step.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is a Line Graph and When Should You Use One?

A line graph, or line chart, is a type of chart that displays information as a series of data points connected by straight line segments. It’s perfect for showing a trend in data over intervals of time - a time-series relationship. Essentially, if you want to see how a number has changed from one period to the next, a line graph is your best friend.

Here are the best-case scenarios for using a line graph:

• Tracking performance over time: This is the most common use. Examples include tracking monthly revenue, daily website users, or quarterly customer acquisition. The continuous line helps you visualize growth, decline, or seasonality.
• Comparing multiple categories over time: You can plot several lines on the same graph to compare the performance of different categories. For example, comparing sales from different regions (North, South, East, West) or traffic from different channels (Organic, Paid, Social) over the same period.
• Identifying trends, patterns, and outliers: A line graph makes it easy to spot upward or downward trends, identify cyclical patterns (like sales spiking every December), and notice any data points that are unusually high or low.

While extremely useful, line graphs aren't a one-size-fits-all solution. If you're comparing static values between categories (like total sales per salesperson for the year), a bar chart is often a clearer choice.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Preparing Your Data for a Line Graph

The secret to a great graph is well-organized data. Before you even click the "Insert" button, arranging your information correctly in Excel will save you a ton of headaches. Your data should be set up in columns or rows with a simple, logical structure.

For a line graph, you generally need two main pieces of information:

1. Time Intervals: These are your labels for the horizontal axis (X-axis). This could be days, months, years, or quarters. They should be in sequential order.
2. Numeric Values: These are the metrics you want to track over time for the vertical axis (Y-axis). This could be sales revenue, website sessions, or subscriber counts.

Let’s say you want to track your website’s traffic from two main sources over an entire quarter. Here’s how you should structure your data:

First, place your time intervals (in this case, months) in the first column. Then, place the numeric values for each data series you want to plot in the subsequent columns, with the headers describing what each series represents.

Here’s an example layout:

Column A: Month (Jan, Feb, Mar, Apr, May, Jun) Column B: Organic Traffic (numerical values) Column C: Paid Traffic (numerical values)

Stick to these best practices when setting up your sheet:

• Use Headers: Always label your columns clearly. Without a header, you (and Excel) won't know what the data represents.
• Keep it Consistent: Ensure your time intervals are consistent (e.g., don't mix days and months in the same column).
• No Blank Rows or Columns: Avoid leaving empty rows or columns in the middle of your dataset, as this can confuse Excel when you go to select your data.

Step-by-Step: How to Create a Basic Line Graph

With your data cleanly organized, creating the graph itself takes just a few clicks. We'll use the website traffic data example from above to create a line graph showing Organic Traffic over time.

1. Select Your Data

Click and drag your cursor to highlight the cells containing the data you want to include in your graph. In our example, you'd select the cells containing the months and the "Organic Traffic" values. Don't forget to include the header row.

2. Go to the "Insert" Tab

At the top of the Excel window, click on the "Insert" tab in the ribbon. This is where all the chart and graph tools are located.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

3. Choose the Line Chart Type

In the "Charts" section of the Insert tab, find the icon that looks like a line graph and click it. This will open a dropdown menu of different line chart options.

• 2-D Line:
• 3-D Line: These are available but generally not recommended for business reporting, as the 3D perspective can distort the data and make it harder to read accurately.

For your first graph, select the first option: the standard 2-D Line graph.

4. Review Your Basic Graph

Excel will instantly generate a basic line graph on your worksheet. It will automatically use your first column (Months) for the X-axis and your second column (Organic Traffic) for the Y-axis. The column header ("Organic Traffic") will be used as the chart title or legend.

And that’s it - you've created a line graph!

Customizing Your Graph for Maximum Clarity

Excel’s basic graph is functional, but taking a few minutes to customize it can turn it from a simple chart into a powerful communication tool. To begin customizing, click anywhere on your new graph. You'll see two new tabs appear on the Excel Ribbon: "Chart Design" and "Format."

Add Chart Elements for Context

You need to give people context for what they're looking at. In the "Chart Design" tab, click the "Add Chart Element" button on the far left. This is your command center for customization.

• Chart Title: Your graph should always have a title. Give it a descriptive name that tells the viewer exactly what data is being shown, such as "Monthly Website Traffic from Organic Search (Q1-Q2)".
• Axis Titles: Label your horizontal (X) and vertical (Y) axes so there's no confusion. The horizontal axis might be labeled "Month," and the vertical axis could be "Number of Sessions."
• Legend: The legend explains what each line on your chart represents. It's essential when you have multiple lines (which we'll cover next) but can often be removed if you only have one data series.
• Data Labels: You can add the specific numeric value next to each data point on the line. This can be useful but can also make your chart look cluttered if you have a lot of data points. Use it wisely.
• Trendline: Want to visualize the overall trend? You can add a trendline (often linear) to show the general direction the data is moving, smoothing out the month-to-month fluctuations.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Adjust Styling and Colors

In the "Chart Design" tab, you'll find a gallery of pre-built "Chart Styles" that let you change the look of your graph with one click. You can also change the colors to match your company's branding.

To change the color of an individual line, right-click the line itself and select “Format Data Series.” A pane will appear on the right where you can adjust the line color, weight, and marker style from the paint bucket icon.

How to Make a Graph with Multiple Lines

Comparing two or more datasets is where line graphs truly shine. The process is nearly identical to creating a single-line graph.

Using our example data, let's create a graph comparing "Organic Traffic" vs. "Paid Traffic."

1. Select All Relevant Data: This time, you'll click and drag to highlight all three columns: Month, Organic Traffic, and Paid Traffic (don't forget the headers).
2. Go to Insert > Line Chart: Follow the exact same steps as before to insert a basic 2-D line graph.
3. Check the Legend: This time, Excel will automatically create two lines and include a legend to tell you which line is which (e.g., a blue line for Organic Traffic and an orange line for Paid Traffic). You can click on the legend to modify or customize it if needed.

Having both lines on the same scale allows you to see immediately how each channel performed relative to the other and whether their trends are similar or divergent.

Common Mistakes to Avoid

• Mismatched Scales: When comparing two series with vastly different values (like revenue in millions and units sold in thousands), it may be helpful to add a secondary axis. You can do this by right-clicking one of the lines and selecting "Format Data Series" > "Plot Series On" > "Secondary Axis."
• Overcrowding the Graph: Plotting too much data can make a line graph unreadable. If you have more than 4-5 lines, consider splitting them into multiple graphs or highlighting only your most important data series.
• Poor Labeling: Never leave a viewer without a title and axis labels. No one should have to guess what your chart is about.

Final Thoughts

Creating an effective line graph in Excel is all about preparing your data properly and spending a few minutes to customize the visuals for clarity. Once you get the hang of it, you'll be able to transform spreadsheets of complex data into digestible insights that effectively tell a story.

We built Graphed because we know how much time is wasted in analyzing work, especially when your data is spreadsheets or Excel analytics. Our platform is designed to help connect your sources and automate key reports and dashboards in one language you understand: visual. Spend less time tinkering with charts and more time making data-driven decisions.