How to Add Multiple Lines in Google Sheets Graph
Visualizing multiple data sets on a single graph can instantly turn a confusing spreadsheet into a clear story. If you're trying to compare different trends over time in Google Sheets, a multiple line graph is the perfect tool for the job. This article will walk you through exactly how to set up your data and create a professional-looking chart with several lines, including how to handle data with completely different scales.
When to Use a Multiple Line Chart
A multiple line chart is your best friend when you want to track and compare the performance of two or more related groups over the same period. It beautifully illustrates relationships, patterns, and differences between data series. Think of it as telling multiple stories at once, on the same timeline.
A few common examples include:
- Sales Performance: Comparing monthly sales figures for several different products or services.
- Marketing Campaigns: Tracking website traffic from various sources like Google, Social Media, and Email over a few weeks.
- Financial Growth: Plotting monthly recurring revenue (MRR) for a few different subscription tiers.
- Operational Metrics: Monitoring customer support tickets opened versus tickets closed each day.
In each case, the goal is to see how different items change and relate to one another over a consistent time interval.
Free PDF Guide
AI for Data Analysis Crash Course
Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.
Step 1: Structure Your Data Correctly
Before you even think about inserting a chart, getting your data layout right is the most critical step. Google Sheets is smart, but it needs your data organized in a specific way to understand how to plot it. If your chart isn't working, the problem almost always starts here.
The golden rule for a multi-line graph is simple:
- Your first column should contain your x-axis values, which are almost always a measurement of time (e.g., Day, Date, Month, Quarter).
- Each subsequent column to the right should contain the y-axis values for one of the lines you want to plot. The column header will become the name of that data series in the chart's legend.
Here’s what a properly structured data set looks like for tracking website sessions from different sources:
Quick Tips for Clean Data
- Keep Your Headers Simple: The headers in Row 1 ("Date," "Organic Search," etc.) will automatically be used to label your lines in the chart legend. Keep them clear and concise.
- Ensure Consistent Formatting: Make sure all your dates are formatted as dates and all your performance numbers are formatted as numbers. Any text mixed in with your numbers can break the chart.
- Avoid Empty Rows: Try to keep your data range contiguous without any completely empty rows separating your data, as this can confuse the chart-building process.
Step 2: Create a Basic Google Sheets Multiple Line Chart
Once your data is neatly arranged, creating the chart takes just a few clicks. Follow these steps to generate your initial graph.
- Select your data range. Click on the top-left cell of your data (e.g., "Date") and drag your mouse down to the bottom-right cell to highlight the entire table. Be sure to include your headers.
- Go to the main menu and click Insert > Chart.
- Google Sheets will automatically analyze your selected data and insert a chart. In most cases, it correctly identifies that you need a line chart.
- If it suggests a different chart type, don’t worry. A Chart editor pane will appear on the right side of your screen. Under the Setup tab, simply click the ‘Chart type’ dropdown and select ‘Line chart.’
Instantly, you should see a chart appear on your sheet with a separate, color-coded line for each of your data columns, along with a helpful legend.
Step 3: Customize Your Chart for Maximum Clarity
The default chart works, but taking a few minutes to customize it will make your data much easier to interpret. All customization options are found in the Chart editor under the Customize tab.
Here are the most important elements to adjust:
Chart & Axis Titles
Always give your chart a clear, descriptive name. Select Chart & axis titles. In the 'Title text' field, enter a name like "Daily Website Sessions by Source." You can also add titles for your horizontal (X) and vertical (Y) axes here, such as "Date" and "Number of Sessions." This context is essential for anyone who views your chart.
Series Customization
This is where you can edit the appearance of each individual line. Under the Customize tab, select Series.
- Use the dropdown menu to toggle between your different data series (e.g., 'Organic Search,' 'Social Media').
- For each series, you can change the line color to match your brand or to create more visual contrast.
- You can also adjust the line thickness or change the line type to dashed or dotted if needed.
Legend
The legend tells the viewer what each colored line represents. Under the Legend section, you can change its position (top, bottom, right, or inside the chart) to optimize your chart's layout and readability.
Advanced Tip: Adding a Second Y-Axis for Different Scales
What if you want to compare two metrics that have completely different units and scales? For example, comparing Website Sessions (measured in tens of thousands) with Conversion Rate (measured as a single-digit percentage)? If you plot these on the same axis, the percentage line will look like a flat line at the bottom, rendering it useless.
The solution is to add a second y-axis. Here’s how.
Imagine your data looks like this:
- Create the multiple line chart using the same steps as before. You’ll immediately see the scale problem.
- Double-click on the chart to reopen the Chart editor pane and navigate to the Customize tab.
- Expand the Series section.
- In the dropdown menu, select the series you want to move to its own axis (in this case, 'Conversion Rate (%)').
- Look for the 'Axis' dropdown below a 'Right axis' option. Select it.
Instantly, a new vertical axis will appear on the right side of your chart, scaled perfectly for your conversion rate data. Now, both lines are clearly visible, and you can analyze the relationship between them. Be sure to add clear axis titles for both the left and right axes to avoid any confusion!
Free PDF Guide
AI for Data Analysis Crash Course
Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.
Troubleshooting Common Issues
If your chart isn't looking right, check for these common problems:
- Messy X-Axis Labels: If your date labels are overlapping, go to Customize > Horizontal axis and use the 'Slant labels' option to angle them for a better fit.
- Strange Line Gaps: Gaps or breaks in your lines often mean there's an empty cell or text-formatted data in that column. Ensure your numerical data is continuous.
- Combined Data Series: If Google Sheets treats all your data as a single series, double-check that the "Use row 1 as headers" box is checked in the Setup tab of the Chart editor.
Final Thoughts
Arranging your data correctly is the most important part of building an effective multiple line chart in Google Sheets. Once you have a logical table structure, you can easily create and customize beautiful graphs that are perfect for comparing different trends over time and discovering valuable relationships in your data.
While mastering Google Sheets is a great skill, we know firsthand that manually pulling data from different apps into spreadsheets for reporting is a slow and tedious process. That's why we created Graphed. Our platform connects directly to all your key business tools like Google Analytics, Shopify, and Facebook Ads, so your data is always unified and up-to-date. Instead of battling with chart settings, you can simply ask questions in plain English, like "Compare sales from Shopify versus ad spend from Google Ads on a line chart for last month," and get an interactive dashboard built for you instantly.
Related Articles
AI Agents for SEO and Marketing: The Complete 2026 Guide
The complete 2026 guide to AI agents for SEO and marketing — what they are, top use cases, the best platforms, real-world examples, and how to get started.
AI Agents for Marketing Analytics: The Complete 2026 Guide
The complete 2026 guide to AI agents for marketing analytics — what they are, how they differ from automation, 10 use cases, pitfalls, and how to start.
How to Build AI Agents for Marketing: A Practitioner's Guide From Someone Who Actually Ships Them
How to build AI agents for marketing in 2026 — a practitioner guide from someone who has shipped a dozen, with the lessons that actually cost time.