How to Make a Line Graph

A line graph is one of the most effective ways to tell a story about how your data changes over time. Whether you're tracking website traffic, monthly sales, or campaign performance, this simple chart can reveal key trends, patterns, and insights at a glance. This guide will walk you through exactly what a line graph is, when to use one, and provide step-by-step instructions for creating them in Google Sheets and Excel.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Line Graph?

A line graph, also known as a line chart, is a type of chart that displays information as a series of data points connected by straight line segments. It’s primarily used to visualize the value of something over a continuous interval of time. The line’s movement across the chart - up, down, flat, or steep - makes it incredibly easy to spot trends.

You’ll typically see two axes:

• The horizontal X-axis most often represents a continuous progression, usually time (e.g., days, weeks, months, years).
• The vertical Y-axis represents the metric you are measuring (e.g., dollars, users, clicks, temperature).

The magic happens when you plot data points at the intersection of these two values (like sales for a specific month) and connect them with a line. This visual connection is what makes trends so obvious.

When Should You Use a Line Graph?

Line graphs are perfect when you need to show change or a trend. Avoid them for showing parts of a whole (that’s for a pie chart) or comparing distinct categories at a single point in time (use a bar chart for that).

Here are some common scenarios where a line graph is the best choice for visualizing your data:

• Tracking Business Performance: Showing monthly revenue, quarterly profits, or year-over-year sales growth.
• Website Analytics: Visualizing daily active users, page views per week, or traffic from different sources over a month.
• Marketing Campaign Monitoring: Graphing ad spend vs. conversions over the life of a campaign to see what's working.
• Comparing Multiple Categories Over Time: Plotting the sales performance of different product lines on the same graph to see which one is growing fastest.
• Financial Analysis: Charting the price fluctuations of a stock or a company’s cash flow over several fiscal years.

The Anatomy of a Line Graph

Before you build one, it helps to know the basic components. Understanding each part will help you customize your charts to make them as clear and informative as possible.

• Chart Title: A clear, descriptive title that tells the viewer exactly what they are looking at. For example, "Monthly Website Traffic (Last 6 Months)."
• X-axis (Horizontal Axis): Represents the independent variable, which is almost always time (days, quarters, years).
• Y-axis (Vertical Axis): Represents the dependent variable - the metric you're measuring and tracking over time (e.g., Sales, Users, Clicks). It should always start at zero if possible to avoid misleading interpretations.
• Data Points (or Markers): These are the specific plots on the chart that represent a value at a given point in time. For instance, a point could represent 5,000 visitors in March. Markers (like dots or squares) make these points easier to see.
• The Line: The line connects the data points, showing the progression and making the trend immediately visible.
• Legend: A small key that explains what each line in the graph represents. This is essential if you are comparing two or more data series on the same chart (e.g., traffic from Google vs. Facebook).
• Axis Labels: Text that describes the units of measurement for both the X and Y axes. For example, the Y-axis label could be "Revenue ($ USD)" and the X-axis label could be "Month."
• Gridlines: Optional faint lines that run across the chart (both horizontally and vertically) to help the viewer more accurately read the values of the data points.

Knowing these terms allows you to find the right settings when it's time to customize your chart and make it truly presentation-ready.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Make a Line Graph in Google Sheets

Google Sheets makes creating a responsive, clean-looking line graph incredibly simple. All you need is your data organized in two columns.

Step 1: Organize and Set Up Your Data

First, open a Google Sheet and enter your data into two columns. Your first column should be your time interval (the X-axis), and the second column should be your metric (the Y-axis). Let’s track website sessions for the first half of the year.

Your data should look like this:

Month Sessions January 12,450 February 14,200 March 15,100 April 13,900 May 16,500 June 18,300

Step 2: Select Your Data

Click and drag your cursor to highlight all the cells containing your data, including the headers ("Month" and "Sessions"). Including the headers helps Google Sheets automatically label your axes.

Step 3: Insert the Chart

With your data highlighted, navigate to the menu at the top and click Insert > Chart. Google Sheets will instantly analyze your data and suggest a chart type. If your data includes a time series, it will often default to a line chart correctly.

Step 4: Choose the Line Chart Type

If Google Sheets didn't automatically select a line chart, you can easily change it. In the Chart editor panel that appears on the right, find the "Chart type" dropdown. Scroll down to the "Line" section and select the first option, a standard Line chart.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 5: Customize Your Line Graph

Now you can fine-tune your chart to make it perfect. In the Chart editor, toggle from the "Setup" tab to the "Customize" tab. Here, you have total creative control.

• Chart style: Change the background color, font, or make the borders smooth for a different look.
• Chart & axis titles: Click here to edit your chart title or add labels for your horizontal (X) and vertical (Y) axes. Give it a descriptive name like "Monthly Website Sessions: January-June 2024". Label your vertical axis "Number of Sessions".
• Series: Change the color of your line, its thickness, or add data point markers (circles, squares, etc.) to make specific values easier to identify.
• Legend: Adjust the position and formatting of your legend if you have multiple lines.
• Gridlines & Ticks: Add or remove gridlines to improve readability.

Once you are happy with the design, you can click and drag the chart to position it anywhere in your spreadsheet or copy it to a Google Doc or Slides presentation.

How to Make a Line Graph in Microsoft Excel

Creating a line graph in Excel follows a very similar process. Its customization options are just as powerful, allowing you to create a clear, professional visualization in minutes.

Step 1: Get Your Data Ready

Just like in Google Sheets, start with well-organized data. Open an Excel worksheet and enter your time series data in the first column and your corresponding values in the second column. Here, we'll track product sales over three months.

Your data in Excel might look like this:

Date Units Sold 1-Jan 210 1-Feb 245 1-Mar 230 1-Apr 280 1-May 310 1-Jun 350

Step 2: Highlight Your Data

Click on the top-left cell of your data set (including the header) and drag your mouse to the bottom-right cell to select all the data you want to include in your chart.

Step 3: Insert a Line Chart

Select the Insert tab in the main navigation ribbon at the top of Excel. In the "Charts" section, look for an icon that shows several lines - this is the "Insert Line or Area Chart" icon. Click it.

Step 4: Select a Chart Type

A dropdown menu will appear with several line graph options under "2-D Line" and "3-D Line." For most cases, a simple "Line" or "Line with Markers" chart is the clearest and most effective option. "Line with Markers” is especially helpful as it places a dot on each data point, making precise values easier to read.

Once you select a type, Excel will immediately generate your chart and place it on your worksheet.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 5: Edit and Customize Your Chart

Excel provides dynamic tools for customization. When your chart is selected, you'll see two contextual tabs appear on the ribbon: "Chart Design" and "Format."

• From the Chart Design tab, you can add chart elements, change the style, switch colors, or even rearrange the data. Use the "Add Chart Element" button to add axis titles and data labels. For example, add "Units Sold This Quarter" as your chart title.
• From the Format tab, you can change the color fill of specific elements, adjust text outlines, and perform more specific design tweaks.

You can also double-click on almost any element of the chart - like the title, an axis, or the line itself - to open a detailed "Format" pane on the right-hand side, giving you even more granular control over its appearance.

Best Practices for Clear and Effective Line Graphs

Creating the chart is only half the battle. Presenting it in a way that viewers can quickly understand is critical.

• Start the Y-Axis at Zero: Whenever possible, start your vertical axis at 0. Starting it at a higher value can exaggerate changes and make minor fluctuations look like massive shifts, which can be misleading.
• Keep It Simple: Avoid cluttering your graph with too many lines. A good rule of thumb is to compare no more than 4-5 series on a single line chart. Any more than that, and it can become a tangled mess that is hard to read.
• Label Everything Clearly: Don't make your audience guess. Use a clear title, label both axes, and state the units being measured (e.g., "$", "%", "Users"). If you have multiple lines, ensure your legend is clear and visible.
• Use Color Strategically: Use different colors for different lines to make them easily distinguishable. Pick colors that are high-contrast and easy on the eyes. Also, consider brand colors if you are creating the chart for an official report or presentation.

Final Thoughts

Line graphs are an essential tool for any business owner, marketer, or analyst looking to understand performance over time. By following the simple steps in tools like Google Sheets and Excel, anyone can turn raw data into a compelling visual story that highlights key trends and insights to drive better decisions.

Once you've mastered creating charts in spreadsheets, you'll find that the process becomes repetitive - especially when you need to update them with fresh data every week. We built Graphed because we wanted to go directly from question to insight, without the manual steps. Instead of pulling CSVs and wrestling with chart settings, we let you simply ask in plain English: "Show me a line graph of my Shopify sales vs. Facebook Ad spend for the last quarter." It connects directly to your live data sources and builds a shareable, interactive dashboard for you in seconds.