How to Plot Data on a Graph in Excel

Transforming rows of raw data into an insightful graph is one of the most powerful features in Excel. A well-designed chart can tell a story that a table of numbers simply can’t. This guide will walk you through plotting data in Excel, from getting your data model ready to customizing your chart to make it shine.

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: Prepare Your Data for Plotting

Before you even think about clicking the 'Insert Chart' button, a little bit of prep work will save you from a lot of frustration. Excel is smart, but it works best with data that's organized logically. A clean data set is the foundation of a clean graph.

Imagine you want to plot your monthly product sales. Your data should be set up in a simple table-like structure:

• Organize in Columns and Rows: Typically, your categories or time periods (like "January," "February") go in the first column, and the corresponding numerical data you want to plot (like "Sales" or "Units Sold") goes in the columns to the right.
• Use Clear Headers: Give each column a distinct, clear header in the first row (e.g., "Month," "Product A Sales," "Product B Sales"). Excel will use these headers to automatically create chart labels and legends.
• Keep It Consistent: Ensure each column contains the same type of data. The "Sales" column should only contain numbers, and the "Month" column should only contain text or date values. Don’t mix text and numbers in a data column you intend to plot.
• No Blank Rows or Columns: Make sure there are no completely blank rows or columns in the middle of your data set. This can confuse Excel and cause it to only select part of your data when you go to create the chart.

Here’s an example of a perfectly formatted data set, ready for plotting:

Month,Laptop Sales,Mouse Sales January,"$15,000","$2,500" February,"$17,500","$2,800" March,"$22,000","$3,100" April,"$19,000","$2,900"

With your data structured this way, Excel will have no problem understanding exactly what you want to visualize.

Choosing the Right Graph for Your Data

The type of graph you choose depends entirely on the story you want to tell. Selecting the wrong chart type can confuse your audience or, worse, lead to incorrect interpretations. Here are a few of the most common graph types in Excel and when to use them.

1. Column or Bar Chart

When to use it: When you're comparing distinct categories against each other. Column charts are great for showing values across different groups, like sales per product, traffic by marketing channel, or inventory levels by warehouse.

Example: You want to see which of your social media channels drove the most website visits last month. A column chart makes it easy to spot the top performers at a glance.

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

2. Line Chart

When to use it: When you want to show a trend over a continuous period of time. Line charts are the standard for tracking changes or progress, such as monthly revenue, weekly website sessions, or daily stock prices.

Example: You need to visualize your company's revenue growth over the last fiscal year. A line chart will clearly show the upward or downward trends from one quarter to the next.

3. Pie Chart

When to use it: When you need to show the composition of a whole - in other words, showing percentages that add up to 100%. Use pie charts sparingly and only when you have a small number of categories (ideally six or fewer).

Example: You want to display the percentage breakdown of your marketing budget by channel (e.g., Google Ads, Facebook Ads, Email Marketing). A pie chart quickly shows which channel gets the biggest piece of the pie.

4. Scatter Plot

When to use it: When you want to see the relationship or correlation between two different numerical variables. It's a great way to spot patterns and identify outliers.

Example: You're trying to determine if there's a connection between your daily ad spend and the number of sales you generate. A scatter plot can reveal if higher spending is actually linked to more sales.

Step-by-Step: Plotting a Column Chart in Excel

Let's walk through creating a basic column chart using our 'Monthly Product Sales' example data. Once you master this process, creating other chart types follows the same general steps.

Step 1: Select 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 highlight the entire range you want to plot.

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

Step 2: Navigate to the Insert Tab

With your data selected, click on the Insert tab in the main Excel ribbon at the top of the screen.

Step 3: Choose Your Chart Type

In the Charts group in the middle of the ribbon, you’ll see icons for different types of graphs. Find the icon for a column or bar chart (it looks like a small column graph). Click on it, and a dropdown menu will appear showing various 2-D, 3-D, and Bar options. For now, let’s choose the first option under 2-D Column, which is a Clustered Column chart.

That’s it! Excel will instantly generate the chart and place it on your worksheet. It will automatically use your "Month" column for the horizontal (X) axis and your "Sales" data for the vertical (Y) axis. Your column headers will be used for the legend and chart title.

Customizing Your Graph to Tell a Better Story

A default Excel chart is a good start, but some fine-tuning can make it far more readable and professional. When your chart is selected, two new tabs will appear on the ribbon: Chart Design and Format. Most of your customization options are found here.

Editing Chart Titles and Axis Labels

Your chart needs a clear title. Don’t settle for the default like "Chart Title."

1. Click directly on the chart title text box at the top of the graph to edit the text. Make it descriptive, like "2023 Monthly Sales Performance."
2. To add labels to your axes (highly recommended), click anywhere on your chart to select it. A small plus sign (+) will appear in the top-right corner. Click it to open the Chart Elements menu.
3. Check the box next to Axis Titles. New text boxes will appear on your vertical and horizontal axes. Click on them to add descriptive labels like "Sales in USD" and "Month."

Changing Colors and Styles

Under the Chart Design tab, you'll find a gallery of pre-built styles and color palettes. You can hover over them to see a live preview. This is the fastest way to improve your chart’s appearance. If you want more control, you can right-click any specific element—like one of the columns—and select Format Data Series to change the fill color, outline, and more.

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

Adding Data Labels

Sometimes, it’s helpful to see the exact value for each data point directly on the chart. In the Chart Elements (+) menu, check the box for Data Labels. The corresponding sales number will appear above each column.

Plotting Multiple Data Series on One Graph

What if you want to compare Laptop Sales vs. Mouse Sales on the same chart from our initial data? The process is just as simple.

1. Select all three columns of data this time (Month, Laptop Sales, and Mouse Sales).
2. Go to Insert > Recommended Charts or select the Column Chart icon again.

Excel will automatically plot both data series on the same chart, using different colored columns for each product and adding a legend so you know which is which. This is great for direct comparisons.

For an even more advanced view, you could create a combo chart. For example, you could show sales as columns and the profit margin as a line on the same graph to see how they relate over time. To do this, create the chart as usual, then right-click on it, select Change Chart Type, and go to the Combo tab to configure your view.

Final Thoughts

Learning how to plot data is an essential Excel skill for anyone who works with numbers. By structuring your data correctly, picking an appropriate graph, and making a few key customizations, you can transform a boring spreadsheet into a powerful communication tool that brings your insights to life.

While Excel is fantastic for hands-on graphing, we know that the cycle of downloading CSVs, cleaning data, and manually building the right chart every week can become overwhelming. We built Graphed to remove that drag entirely. Instead of clicking through menus, you connect your business platforms - like Shopify, Google Analytics, or Salesforce - and use plain English to ask for the data you want to see. It generates interactive, real-time dashboards so you can stop wrestling with pivot tables and spend your time discovering what your data is actually telling you.