How to Create a Graph in Excel with Multiple Columns

Trying to visualize data from several different columns in Excel can feel like a headache waiting to happen, but it’s actually more straightforward than you might think. This guide will walk you through how to create clear, insightful graphs using multiple data columns. We’ll cover choosing the right chart, step-by-step creation instructions, and a few tips to make your charts look professional.

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

First Things First: Structure Your Data Correctly

Before you even think about clicking the "Insert Chart" button, the single most important step is to organize your data properly. Excel graphs work best with a simple, clean table structure. For graphs with multiple columns, this means your data should be arranged in a grid.

Think of it this way:

• First Column (Column A): This should contain your labels or categories. These will typically become your horizontal axis (the X-axis). This could be months, years, product names, sales regions, or marketing channels.
• Subsequent Columns (Column B, C, D, etc.): Each of these columns should contain a separate set of numerical data that you want to plot. These are your data series. Each column header will be used in the chart's legend to identify what the data represents.

Here’s a practical example showing monthly sales for three different products. This is the ideal layout for creating a multi-column graph:

Keep your table free of empty rows or columns within the data set. A contiguous block of data like the one above makes it seamless for Excel to understand what you're trying to plot.

Choosing the Right Chart Type for Multiple Columns

Once your data is organized, the next step is to pick a chart type that best communicates the story behind your numbers. With multiple data series, some charts work much better than others.

Clustered Column or Bar Chart

Best for: Directly comparing values across categories.

A clustered column chart places bars for each data series side-by-side for each category. This makes it incredibly easy to see, for example, which product sold the most in January or how Product A's sales compared to Product C's in March. A bar chart works similarly, just oriented horizontally.

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

Line Chart

Best for: Showing trends over a continuous period, like time.

If your horizontal axis represents dates, months, or years, a line chart is an excellent choice. Each data column becomes its own line, so you can easily track and compare the performance trends of different series over time. Did all product sales peak during a specific season? Is one product's sales growth outpacing the others?

Stacked Column or Bar Chart

Best for: Showing how parts contribute to a whole across categories.

A stacked column chart stacks the values from each data series on top of one another within a single column for each category. This is great for visualizing the total sum across all series while also showing the relative contribution of each part. For instance, you could see total company sales per month, with the colored segments of each column showing how much each product contributed to that total.

Combo Chart

Best for: Visualizing two different types of data on the same graph.

What if you want to plot sales data (in dollars) alongside units sold or a conversion rate (a percentage)? The scales are completely different. A combo chart solves this by allowing you to mix chart types–like columns for sales and a line for conversion rate–and use a second vertical axis (a secondary axis) for the second measure.

Step-by-Step Guide: Creating Your Multi-Column Graph

Let’s walk through the exact steps using our sample sales data. We'll start with the most common choice: a clustered column chart.

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

How to Make a Clustered Column Chart

This is your go-to for comparing distinct values.

1. Select Your Data: Click and drag your mouse to highlight the entire range of data you want to plot, including the column headers and the row labels. For our example, you'd select cell A1 through D4.
2. Go to the Insert Tab: At the top of the Excel window, click on the Insert tab on the ribbon.
3. Choose Your Chart: In the Charts group, find the icon that looks like a column chart ("Insert Column or Bar Chart"). Click it, and a dropdown menu will appear.
4. Select "Clustered Column": Under the "2-D Column" heading, hover over the first option. It will say "Clustered Column." Click on it.

Excel will instantly generate the chart and place it on your worksheet. You will see "Months" along the bottom (X-axis) and sales values on the side (Y-axis). Each product will have its own color-coded bar for each month, and a legend will identify which color corresponds to which product.

How to Make a Line Chart with Multiple Lines

Let's plot the same data as a line chart to visualize trends over the quarter.

1. Select Your Data: Again, highlight your full data range (A1 through D4).
2. Open the Insert Tab: Click the Insert tab.
3. Choose the Line Chart: Find the line chart icon ("Insert Line or Area Chart"). Click it.
4. Select "Line with Markers": From the "2-D Line" options, choose "Line with Markers." This is usually a good choice because it places a dot on each data point, making it easier to read.

The chart will now show three separate lines, one for each product, allowing you to easily compare their sales performance trajectories over time.

How to Make a Combo Chart with a Secondary Axis

Let's make this more interesting. Imagine we have total sales and also the profit margin percentage for each month. The sales are in thousands of dollars, and the margin is a small percentage. Plotting them on the same axis would make the margin line look flat and useless.

Here's our new data:

1. Select the Data: Highlight cells A1 through C4.
2. Open the Combo Chart Dialog Box: Go to Insert > Charts > Insert Combo Chart (it's the icon showing both a column and a line). Choose "Create Custom Combo Chart..." at the bottom.
3. Configure Your Series: A dialog box will appear.
4. Add a Secondary Axis: Check the box in the "Secondary Axis" column next to "Profit Margin." You'll see a preview of what the chart will look like.
5. Create the Chart: Click OK.

You’ll get a beautiful chart showing sales as columns (measured by the primary Y-axis on the left) and the profit margin trend as a line (measured by the secondary Y-axis on the right).

Customizing Your Graph for a Professional Look

A default Excel chart is a good start, but a few tweaks can make it much easier to understand at a glance.

Add Clear Titles and Labels

Never leave your audience guessing. Click on the chart, and a plus sign ("+") icon will appear in the upper right corner.

• Chart Title: Check this option and replace "Chart Title" with a descriptive title like "Q1 Product Sales Performance."
• Axis Titles: Check this box to add titles for both your horizontal and vertical axes. Label them clearly (e.g., "Month" and "Total Sales ($)").

Adjust the Legend and Data Labels

The legend identifies what each color or line means. You can click and drag it to a better position (like the top or right). For even more clarity, consider adding data labels directly to your chart. Click the "+" icon, check "Data Labels," and the exact value will appear on top of each bar or next to each line marker.

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

Quick Fixes for Common Problems

Problem: "My data is on the wrong axis!"

Solution: Excel sometimes guesses wrong about what should be on the X-axis versus in the legend. To fix this, click your chart, go to the Chart Design tab on the ribbon, and click the "Switch Row/Column" button. This will quickly swap them.

Problem: "My chart is too crowded!"

Solution: A chart with 20 different data series will be unreadable. Reconsider what you're trying to show. Maybe a different chart type (like a stacked area chart) is a better choice, or perhaps you should plot only the top 5 most important series and group the rest into an "Other" category.

Final Thoughts

Graphing data from multiple columns in Excel is a straightforward process when you begin with well-organized data and a clear idea of what you want to communicate. By selecting the appropriate chart type - be it a column, line, or combo chart - and making a few simple customizations, you can transform complex data into a clear and compelling visual story.

While mastering Excel is a valuable skill, we know it can become a time-sink - especially when your VLOOKUPs break or you’re manually exporting CSVs from SaaS tools like Shopify, Salesforce, or Google Analytics every week. At Graphed, we created a solution where you can just ask your data questions in plain English. Instead of spending an hour building charts, you can simply ask, "create a combo chart showing sales from Shopify and ad spend from Facebook Ads for the last quarter," and we’ll build and refresh a live dashboard for you in seconds.