How to Get a Graph in Excel

Turning a spreadsheet packed with numbers into a clear, visual story is a core skill for anyone working with data. Creating a graph (or chart) in Excel is one of the fastest ways to spot trends, compare results, and share insights with your team. This tutorial will guide you through choosing the right graph and building it step-by-step, transforming your raw data into a professional-quality visualization in minutes.

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

Before You Begin: Prepare Your Data for Graphing

Before you can make a graph, Excel needs your data to be organized in a logical way it can understand. Junk data in means junk data out. A few minutes of setup will save you a headache later.

Your data should be structured like a table with clear headers. Follow these simple rules:

• Column Headers: Your top row should contain unique, descriptive headers for each column (e.g., "Month", "Website Visitors", "Sales"). This tells Excel what each data series represents.
• Consistent Rows: Each row below the header should represent a single entry or time period (e.g., one row for January, one for February, etc.).
• No Blank Rows or Columns: Make sure your core data range is a solid block without any completely empty rows or columns in the middle. This helps Excel automatically detect the data you want to graph.

Here’s a perfect example of a well-structured data set, ready for graphing:

Month, Sales Revenue, Ad Spend January, $15,000, $1,200 February, $18,500, $1,500 March, $22,000, $1,800 April, $20,500, $1,600 May, $25,000, $2,100 June, $28,000, $2,500

With clean data like this, telling Excel what to plot is simple and error-free.

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

Choosing the Right Type of Graph

Excel offers a huge library of charts, but you only need to know a few key types to handle most business reporting needs. The type of graph you choose depends entirely on the story you want to tell with your data.

Column or Bar Charts: For Comparing Categories

These are your go-to charts for comparing values across different categories. They are easy to read and universally understood.

• When to use them: Comparing sales figures for different products, looking at website traffic from various social media channels, or tracking survey responses by demographic.
• Column vs. Bar: A column chart uses vertical bars (best for when you have fewer categories). A bar chart uses horizontal bars (great when you have long category names or many categories to display).

Line Charts: For Showing Trends Over Time

Line charts are perfect for illustrating how a value changes over a continuous period, like days, months, or years.

• When to use them: Tracking monthly revenue, daily stock prices, website users over a quarter, or any other time-series data. The connecting line makes it easy to see trends, upward or downward swings, and seasonality.

Pie Charts: For Showing Parts of a Whole

Pie charts show how individual parts contribute to a total, representing percentages of 100%. While popular, they should be used carefully.

• When to use them: Showing the percentage breakdown of a budget, market share for different competitors, or the proportion of marketing leads from different sources.
• A quick tip: Pie charts become difficult to read if you have more than 5-6 slices. If you have many categories, a bar chart is a clearer choice.

Scatter Plots (XY Charts): For Showing Relationships

A scatter plot is used to see if there's a relationship, or correlation, between two different numerical variables.

• When to use them: Plotting a marketer’s ad spend against revenue to see if they're correlated, or comparing average daily temperature to ice cream sales. Each dot on the graph represents a single data point with two values (X and Y).

How to Make a Graph in Excel: A Step-by-Step Guide

Let's use our sample sales data to create a simple column chart showing monthly revenue. The process is the same for virtually any chart type.

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 1: Select Your Data

Click and drag your mouse to highlight the cells containing the data you want to graph. Be sure to include your row and column headers. For our example, you would highlight the range containing "Month" and "Sales Revenue," along with all the corresponding data points.

Step 2: Navigate to the Insert Tab

At the top of the Excel window, click on the Insert tab in the ribbon. Here you will find the Charts section, where all the graphing magic happens. You’ll see icons for various chart types like column, line, and pie.

Step 3: Choose Your Chart Type

For this example, let's create a column chart.

• In the Charts section, click on 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 Column, 3-D Column, 2-D Bar, etc.
• Hover over an option to see a live preview of what your chart will look like with your data. For now, just select the first option under 2-D Column (a Clustered Column chart).

Instantly, Excel will place a new chart object onto your worksheet displaying your sales data.

Level Up: Customizing Your Graph for Clarity and Impact

A basic chart gets the job done, but a well-formatted chart tells a clearer story. When you click on your chart, two new contextual tabs will appear in the ribbon: Chart Design and Format. These tabs contain all the tools you need to customize your visualization.

Add a Clear and Descriptive Chart Title

Your chart's default title will likely be something generic like "Sales Revenue." Click on the title text to edit it to something more descriptive, like "Monthly Sales Revenue - Q1 & Q2."

Add Axis Titles and Data Labels

What do the numbers on the vertical (Y) and horizontal (X) axes represent? Without labels, no one knows! To add them:

1. Click on your chart to select it.
2. Click the green “+” icon (Chart Elements) that appears on the top-right corner of the chart.
3. Check the box for Axis Titles. New text boxes will appear on your chart. Click them to add labels like "Total Revenue ($)" for the vertical axis and "Month" for the horizontal axis.
4. From the same menu, you can check Data Labels to display the exact numerical value on top of each corresponding column or bar.

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

Adjusting Colors and Styles

The Chart Design tab offers a quick way to change the entire look and feel of your graph.

• Chart Styles: This gallery provides pre-made design templates with different backgrounds, fonts, and bar styles. It’s a fast way to make your chart look more professional.
• Change Colors: Click this button to apply a different color palette. You can choose from a range of professional color kits, including monochromatic schemes. This is great for matching a chart to your company's branding.

These simple tweaks can turn a boring default chart into a polished, easy-to-read piece of communication.

Pro-Tips for Better Excel Graphs

Ready to move past the basics? Here are a few tips to make your graphing workflow faster and your visualizations more powerful.

1. Use the Quick-Chart Shortcut: Select your data and press Alt + F1 (or Fn + Alt + F1 on some laptops). This instantly creates a default column chart on the same worksheet, saving you several clicks.
2. Create a Combo Chart: Sometimes you need to show two different types of data on one graph. For example, you might want to show sales revenue as columns and the number of new customers as a line. You can do this with a "Combo Chart." After creating a chart, go to Chart Design > Change Chart Type > Combo. Here, you can assign a different chart type for each data series and even plot one on a secondary axis.
3. Automate Updates with Excel Tables: If you regularly add new data to your table (e.g., a new month's sales figures), you should turn your data range into an official Excel Table first. Select your data and press Ctrl + T. Now, when you create a graph based on this table, it will automatically update to include any new rows you add. No more manually resizing your data source!

Final Thoughts

Creating graphs in Excel is a fundamental skill that transforms your raw data from a simple list of numbers into a visual story with actionable insights. By preparing your data, choosing the right chart, and adding a few key customizations, you can build clear and professional visuals that help you and your team make smarter decisions.

Excel is indispensable for quick, one-off analyses, but manually pulling data and rebuilding the same reports week after week can become a major time-sink. We built Graphed to automate that entire workflow. You just connect your business software - like Google Analytics, Shopify, or Salesforce - and ask for the dashboards and reports you need in plain English. This allows your entire team to get real-time answers faster, so you can spend less time updating spreadsheets and more time acting on insights.