How to Graph Two Columns in Excel

Transforming two columns of data into a clear, insightful chart is one of the most powerful features in Excel. A well-made graph can reveal trends, highlight comparisons, and tell a story that raw numbers alone can't. This guide will walk you through exactly how to graph two columns in Excel, from selecting your data to customizing your chart so it looks polished and professional.

First, Choose the Right Chart for Your Story

Before you even click "Insert," think about what you want your data to communicate. The relationship between your two columns determines the best type of chart to use. Choosing the right one is the first step toward creating a chart that makes sense.

Here are the most common charts for two-column data and what they're best for:

• Column or Bar Chart: Perfect for comparing values across different categories. Use this if one column has text labels (like "Product A," "Product B") and the other has corresponding numbers (like "Sales"). A bar chart is just a column chart flipped horizontally, which works well if your category names are long.
• Line Chart: The best choice for showing a trend over time. Use a line chart if your first column contains sequential data like dates, months, or years, and your second column contains a corresponding metric like revenue, website visitors, or temperature.
• Scatter Plot: Use this when you want to see the relationship between two columns of numerical data. A scatter plot helps you identify correlations, like whether an increase in advertising spend (Column 1) corresponds with an increase in sales (Column 2).
• Pie Chart: Ideal for showing parts of a whole. A two-column setup for a pie chart would typically have a short list of categories in one column and their corresponding percentages or values in the other. Note: Use pie charts carefully - they become hard to read with more than a few categories.

Setting Up Your Data for Success

Excel does a fantastic job of guessing what you want your chart to look like, but it needs your data to be formatted in a simple, predictable way. For two-column graphing, the rules are easy:

• Use Headers: Put a clear header at the top of each column. One for your categories or time period (the x-axis) and one for your values (the y-axis). Excel will use these headers to automatically label your chart.
• Keep It Simple: Your data should be in two adjacent columns. For example, have "Month" in column A and "Revenue" in column B.
• No Empty Cells: Make sure there are no empty rows or columns in the middle of your data set. This can confuse Excel and lead to a malformed chart.

How to Graph Two Columns in Excel: A Step-by-Step Guide

Let's walk through creating a basic column chart using the monthly revenue data from above. Once you master this process, creating other chart types follows the same logic.

Step 1: Select Your Data

Click and drag your mouse to highlight all the cells containing your data, including the column headers. In our example, you would select cells A1 through B7. Including the headers is important because Excel will use them to create the chart title and axis labels automatically.

Step 2: Go to the "Insert" Tab

At the top of the Excel window, click on the Insert tab in the ribbon. This is where you'll find all of Excel's charting and visualization tools.

Step 3: Choose Your Chart Type

In the Charts section of the Insert tab, you'll see small icons representing different chart types. You can hover over them to see a preview. For this example, we'll create a column chart.

• Click the icon that looks like a small column chart ("Insert Column or Bar Chart").
• A dropdown menu will appear with different styles, like 2-D, 3-D, and stacked columns. For most purposes, a simple 2-D Clustered Column chart is the clearest and most effective option. Click it.

That's it! Excel will instantly place a new chart directly onto your worksheet. It automatically puts your "Month" data on the horizontal (x-axis) and your "Revenue" data on the vertical (y-axis).

Making Your Graph Look Professional

A default chart gets the job done, but taking a few minutes to customize it will make it much easier for others to understand. When you click on your chart, two new tabs will appear in the ribbon: Chart Design and Format.

You can also click the small "+" button that appears on the top-right corner of a selected chart to add or remove chart elements quickly.

Add a Clear Chart Title

Your chart automatically gets a title, usually from your value column's header (e.g., "Revenue"). Double-click the title to edit it. Make it descriptive and concise. For example, "Monthly Revenue (Jan-Jun)" is much clearer.

Label Your Axes

A chart without labeled axes is basically useless. Make it easy for your audience to know what they're looking at.

1. Click on your chart to select it.
2. Click the "+" icon (Chart Elements) on the top-right.
3. Check the box next to Axis Titles.
4. New text boxes will appear for the vertical and horizontal axes. Double-click them to edit the text (e.g., "Month" and "Revenue in USD").

Adjusting Colors and Styles

The default blue might not fit your presentation or brand. To change it, click on a data series (like one of the blue columns) to select all of them. Then, right-click and choose Format Data Series. A panel will open on the right where you can change the fill color and border.

For quicker edits, use the Chart Design tab. This tab offers pre-made styles and color palettes that can give your chart a professional look with just one click.

Advanced Example: Creating a Scatter Plot

What if you wanted to see if there's a relationship between two numerical columns, like Ad Spend and Website Conversions? A scatter plot is the perfect tool for this.

1. Set up your data: Put "Ad Spend" in Column A and "Website Conversions" in Column B.
2. Select the data: Highlight both columns, headers included.
3. Insert chart: Go to the Insert tab, click the icon for a scatter plot ("Insert Scatter (X, Y) or Bubble Chart"), and choose the first option.

Excel will plot "Ad Spend" on the x-axis and "Website Conversions" on the y-axis. Each point on the graph represents one row of data. If the points generally move upwards from left to right, it suggests a positive correlation - as you spend more, you get more conversions.

Bonus Tip: Add a Trendline

To make the correlation even clearer, you can add a trendline to a scatter plot.

• Click your chart, then click the "+" icon.
• Click the arrow next to Trendline and select Linear.
• A dotted line will appear, showing the general trend of your data.

Common Pitfalls and How to Avoid Them

Building a chart from two columns is usually straightforward, but there are a few stumbling blocks that can trip up even experienced users:

• Missing Your Chart Type: The most common error is using the wrong chart. If you use a line chart to compare categories like "Product Sales," it will imply a trend that doesn't exist. Always go back to the basics: use lines for time, and column/bar charts for categories.
• Incorrect Data Selection: If you accidentally include empty rows at the bottom of your data, it can create an awkward gap in your chart. Always double-check your selected range before creating the graph.
• Not Labeling Axes or Titles: Any chart without a clear title and axis labels is just a collection of bars and lines. It's impossible to extract meaning without context. Always label everything clearly.

Final Thoughts

Creating a visual representation from two columns of data in Excel is a straightforward process. By picking the right chart type and adding a few customizations, you can transform a boring spreadsheet into a compelling story that reveals trends, comparisons, and correlations at a glance.

For business users scattered across multiple platforms like Shopify, Google Analytics, or Salesforce, the manual work of exporting CSVs and building Excel charts repeatedly can consume an entire day of your week. We built Graphed because we knew there had to be a better way to do it. Our AI platform connects to all your data sources, allowing you to create real-time dashboards with simple natural language commands instead of manually updating Excel dashboards weekly. We'll keep your dashboards live and up-to-date automatically, freeing you to spend time acting on your insights instead of just gathering the right metrics.