How to Graph Numbers in Excel

Turning a spreadsheet full of numbers into a clear, understandable graph is one of the most powerful features in Excel. A visual chart can reveal trends, highlight comparisons, and communicate insights far more effectively than a raw data table ever could. This guide will walk you through exactly how to create and customize graphs in Excel, from preparing your data to finalizing a professional-looking 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

Why Bother Graphing Your Data?

Before jumping into the "how," it helps to understand the "why." You probably already have a feeling for it, but let's put it simply: our brains are wired to process visual information. When you look at a spreadsheet with rows and columns of sales figures, your brain has to work hard to find patterns. A graph does that work for you.

• Spot Trends Instantly: Is revenue going up or down over the last year? A line chart makes the answer obvious in a single glance.
• Compare Values Easily: Which product category is your top performer? A bar chart lines them up side-by-side for an instant comparison.
• Communicate Your Story: Presenting to your team or clients? A well-designed chart helps your audience understand the key takeaways without getting lost in the numbers.

Step 1: Get Your Data Ready for Graphing

The number one rule of creating a good graph is starting with good, well-structured data. Excel is smart, but it needs your data organized in a way it can understand. If your charts aren't looking right, problems with your data setup are the most common cause.

Follow these simple rules for a perfect setup:

• Use Headers: Put a clear, descriptive header at the top of each column. For example, "Month" and "Sales." This tells Excel what each set of data represents.
• Keep It Tidy: Arrange your data in adjacent columns or rows. Your labels for the horizontal axis (like months, product names, or countries) should be in the leftmost column, and the corresponding numerical values you want to plot should be in the column(s) immediately to the right.
• No Blank Rows or Columns: Avoid leaving empty rows or columns in the middle of your dataset, as this can confuse Excel when you select your data.

Here’s a perfect example of a simple, graph-ready dataset:

A B

1 | Month | Website Sessions 2 | January| 12,450 3 | February|14,200 4 | March | 17,800 5 | April | 15,900 6 | May | 19,100 7 | June | 21,300

In this example, Column A contains the labels (months), and Column B contains the numerical values (sessions) we want to visualize.

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

Step 2: Choose the Right Chart for Your Numbers

Excel offers a huge variety of chart types, and choosing the right one depends entirely on the story you want your data to tell. Using the wrong chart can be confusing or even misleading. Here’s a quick guide to a few of the most common types and when to use them.

Column or Bar Charts

These are the workhorses of data visualization. Use them when you want to compare values across different categories.

• Column Chart: Categories are organized along the horizontal axis, and values are shown on the vertical axis (vertical bars). Ideal for things like comparing sales figures for different products.
• Bar Chart: Essentially a column chart flipped on its side (horizontal bars). They work great when you have long category labels that won't fit well on the horizontal axis.

Use for: Comparing quarterly revenue, social media followers by platform, or sales by region.

Line Charts

Line charts should be your go-to whenever you want to show a trend over time. They connect individual data points to show continuity, making it incredibly easy to see if a metric is increasing, decreasing, or staying flat.

Use for: Tracking website traffic over 12 months, showing stock price changes, or plotting temperature changes over a week.

Pie Charts

Pie charts are designed to do one thing: show the parts of a whole, representing numbers in percentages. Each slice of the pie represents a category's contribution to a total.

Heads up: Pie charts get messy and hard to read if you have more than 5 or 6 categories. If you have many categories, a bar or column chart is almost always a better choice.

Use for: Displaying the percentage breakdown of a marketing budget, showing survey responses (e.g., % Yes, No, Maybe), or illustrating market share among a few competitors.

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

Scatter Plots (XY Charts)

A scatter plot is used to see if there’s a relationship between two different numerical variables. Each point on the graph represents a single data point with two values. You can then see if the points form a meaningful pattern, like a line or a curve.

Use for: Investigating the relationship between advertising spend and sales revenue, or between hours studied and test scores.

Step 3: Creating Your Graph in Excel

Once your data is clean and you know which chart type you want, creating the graph is just a few clicks away. We'll use our "Website Sessions" example data from earlier.

1. Select Your Data: Click and drag your mouse to highlight the entire range of data you want to include in the graph, including the column headers. In our example, you’d select cells A1 through B7.
2. Go to the Insert Tab: Look at the top Excel ribbon and click on the Insert tab.
3. Find the Charts Group: In the middle of the Insert ribbon, you'll see a group called Charts. Here, you'll find icons for all the different chart types.
4. Use "Recommended Charts" (for beginners): If you're unsure which chart to use, the Recommended Charts button is a fantastic feature. Excel will analyze your data and suggest a few chart types that would be a good fit. This is often the easiest and fastest way to get started.
5. Choose a Specific Chart Type: For our "Website Sessions" data, a line chart is perfect for showing the trend over time.

Excel will instantly generate the chart and place it on your worksheet. And just like that, you’ve turned a simple table of numbers into a visual trendline!

Step 4: Customizing Your Graph for a Professional Look

The default chart Excel creates is a great starting point, but with a few simple tweaks, you can make it much clearer, more professional, and easier for your audience to understand.

When you click on your new chart, two new tabs will appear on the ribbon: Chart Design and Format. You'll also see some icons appear on the right side of the chart itself.

Add and Edit Chart Elements

On the right side of your chart, you’ll see a green plus sign (+). This is the Chart Elements shortcut, and it’s the easiest way to add or remove parts of your graph.

• Chart Title: Your chart should always have a clear, descriptive title. Click on the default "Chart Title" text box at the top and type in something more meaningful, like "Monthly Website Sessions (Q1-Q2)."
• Axis Titles: It's good practice to label your axes. Click the (+) button, check the box for Axis Titles, and then edit the new text boxes that appear for the horizontal and vertical axes (e.g., "Month" and "Number of Sessions").
• Data Labels: Sometimes it's helpful to see the exact value for each data point directly on the chart. Click the (+), and check Data Labels to add them.
• Legend: If you're plotting multiple data series (e.g., sessions from 2023 and 2024), a legend is essential. Use this option to add, remove, or change its position.

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

Change Colors and Styles

Under the Chart Design tab, you’ll find several options to quickly change the look of your graph.

• Chart Styles: This is a gallery of pre-built design styles. Hover over them to see how your chart would look with different themes, backgrounds, and font styles.
• Change Colors: The button right next to Chart Styles allows you to pick from various pre-set color palettes, ensuring your chart looks visually appealing and aligns with your brand colors.

For more specific formatting, you can right-click on any element of the chart - like the bars, the line, the plot area, or a title - and select the "Format..." option from the dropdown menu. This will open a detailed formatting pane on the right-hand side, giving you complete control over colors, outlines, shadows, text effects, axis scales, and much more.

Final Thoughts

Graphing numbers in Excel is an essential skill that transforms rows of data into actionable insights. By preparing your data properly, choosing the right chart type, and adding a few key customizations, you can create compelling visualizations that tell a clear and persuasive story.

While mastering Excel is incredibly useful for detailed analysis, the weekly and monthly grind of exporting raw numbers from various platforms, cleaning them up, and repeatedly building the same reports can be a huge time-drain. At Graphed, we have created dedicated software that automates this entire process. We connect directly to your data sources - like Google Analytics, Shopify, or HubSpot - so you can use simple natural language prompts to instantly create live, interactive dashboards that are always up-to-date, saving you hours of manual work.