How to Graph a Table in Excel

Creating a graph from a table in Excel is one of the fastest ways to understand what your numbers are actually telling you. A well-designed chart can reveal trends, comparisons, and outliers that are easily lost in a wall of data. This guide will walk you through turning your raw Excel data into a clear and insightful graph, covering everything from choosing the right chart type to customizing it for a professional presentation.

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, Get Your Data Ready for Graphing

Before you even think about charts, the quality of your graph depends entirely on the quality of your data structure. A little bit of organization upfront makes the entire process smoother.

Your data should be set up in a simple, logical table format. Here’s a quick checklist:

• Clear Headers: Each column needs a unique, descriptive header in the first row. For example, use "Month," "Product Category," and "Revenue" instead of generic labels.
• No Empty Rows or Columns: Ensure there are no completely blank rows or columns chopping up your data. This can confuse Excel when it tries to automatically detect your data range.
• Be Consistent: Keep the data type within each column the same. Don't mix text and numbers in a column that should only contain revenue figures. Make sure your dates are all formatted as dates.

Pro-Tip: Use Excel's "Format as Table" Feature

One of the best things you can do is convert your data range into an official Excel Table. It’s a simple step with powerful benefits. Just click anywhere within your data range and press Ctrl + T (or Cmd + T on a Mac). A small dialog box will appear to confirm your data range, make sure the "My table has headers" box is checked, and click OK.

Why do this? When your data is in an official Table, any charts you create from it become dynamic. If you add a new row of data (e.g., sales for a new month), your graph will automatically update to include it. This saves you from having to manually adjust your chart's data source every time something changes.

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

Choose the Right Chart Type for Your Story

Excel offers dozens of chart types, but a handful will cover almost every common business scenario. Choosing the right one is crucial for communicating your message effectively. The type of chart you choose depends on what you want to show.

Column or Bar Charts: For Comparing Categories

If you need to compare discrete categories against each other, a column or bar chart is your best friend. They are incredibly easy to read and universally understood.

• Use them when: You want to compare values across different groups.
• Example: Comparing total revenue for different product lines (e.g., "Electronics," "Apparel," "Home Goods") or sales performance across different regions.

Line Charts: For Showing Trends Over Time

When your data has a time-series component (like days, months, quarters, or years), a line chart is the ideal choice. It connects data points to show how a value changes and reveals trends, seasonality, or fluctuations.

• Use them when: You want to track changes over a continuous period.
• Example: Showing website traffic month-over-month for the past year or tracking weekly sales figures to spot growth patterns.

Pie Charts: For Showing Parts of a Whole

Pie charts show the proportion each category contributes to a total. They work best when you want to illustrate composition, such as market share or budget allocation.

• Use them when: You're showing percentages that add up to 100%.
• Example: Breaking down the sources of website traffic for a single month (e.g., 50% Organic, 30% Paid, 20% Direct).
• A word of caution: Avoid using pie charts with more than 5-6 categories. Too many slices make the chart cluttered and impossible to read. A bar chart is often a clearer alternative.

Scatter Plots: For Showing Relationships

A scatter plot is used to observe and show the relationship between two numeric variables. Each dot on the plot represents an observation from your dataset, positioned according to its values on the horizontal (X-axis) and vertical (Y-axis) scales.

• Use them when: You want to see if one variable has an effect on another.
• Example: Plotting daily ad spend versus daily sales to see if there's a correlation. Does more ad spend lead to more sales? A scatter plot can help you see the pattern.

Step-by-Step: How to Create a Graph from Your Table

Once your data is clean and you've decided on the right chart type, creating the graph takes just a few clicks. Let's use a simple sales data table as an example:

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 the Data

Click and drag your mouse to highlight the cells you want to include in your graph. In our example, you would select the range containing everything from "Month" to the last profit number.

Step 2: Head to the "Insert" Tab

At the top of the Excel window, click on the Insert tab in the ribbon.

Step 3: Choose Your Chart Type

Look for the "Charts" section within the Insert tab. Here you will see icons for all the different chart types. For our example, a column chart is a good choice to compare revenue and profit each month. Click on the Column chart icon and select the first option, "Clustered Column."

Alternatively, you can click on "Recommended Charts". Excel will analyze your selected data and suggest a few chart types that it thinks are a good fit. This is a very helpful feature if you're not sure which chart to use.

Voilá! Excel will instantly create a chart and place it on your worksheet.

Making Your Graph Look Professional

An automatically generated chart is a good start, but a few customizations can turn it from a simple visual into a powerful communication tool. When you select your chart, two new tabs called "Chart Design" and "Format" appear on the ribbon. You can also use the three icons that appear to the top right of the chart itself.

Add Chart Elements (The "+" Icon)

Click the green plus sign to add or remove key elements. Some of the most important are:

• Chart Title: Your chart should always have a clear, descriptive title. Replace the generic "Chart Title" with something specific like "Monthly Revenue and Profit Performance - Q1."
• Axis Titles: It's essential to label your X and Y axes so viewers know what they're looking at. In our example, the Y-axis title would be "Amount ($)" and the X-axis would be "Month."
• Data Labels: Sometimes it's useful to show the exact value for each bar or data point. Data labels add these numbers directly onto the chart, so your audience doesn’t have to guess.
• Legend: A legend is necessary when you plot multiple data series, like our revenue and profit columns. It tells the viewer what each color represents. You can also move it to the top, bottom, left, or right for better layout.

Change Styles and Colors (The Brush Icon)

Excel comes with a gallery of pre-built chart styles and color palettes. Clicking the paintbrush icon allows you to quickly cycle through different designs to find one that fits the look and feel of your report or presentation. You can change themes from professional and muted to bold and colorful with a single click.

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

Filter Data on the Fly (The Funnel Icon)

This handy feature allows you to temporarily hide parts of your data without editing the source table. For example, if you wanted to see a chart showing only revenue, you could click the funnel, uncheck the box for "Profit," and click "Apply." The profit columns will disappear from your chart instantly.

Advanced Tip: Creating a Combination Chart

What if you want to show revenue as bars but overlay a line showing profit margin percentage on the same graph? This requires a combination chart with a secondary axis.

1. Start by creating a standard column chart with both your revenue and profit margin data.
2. Right-click on one of the data series you want to change (e.g., the profit margin bars) and select "Change Series Chart Type..."
3. In the dialog box that appears, you can assign a different chart type to each data series. Change the chart type for "Profit Margin" to a Line chart.
4. To make it readable, check the "Secondary Axis" box next to the profit margin series. This will create a new vertical axis on the right side of the chart scaled to your percentages.

You now have a sophisticated chart showing the relationship between two different types of measurements in one clean visual.

Final Thoughts

Turning table data into graphs in Excel is a fundamental data analysis skill. By properly structuring your data, selecting the appropriate chart type, and adding clear titles and labels, you can transform boring spreadsheets into compelling visual stories that are easy for anyone to understand.

While Excel is powerful for this kind of work, you might find yourself repeating the same download-and-create process with data from other tools like Google Analytics, Shopify, or Facebook Ads. At Graphed, we automate the entire reporting process. Instead of working with static CSV files, you can simply connect your data sources to our platform and create real-time, interactive dashboards by describing what you want to see - all using plain English. We built it to help you get answers from your complete business data in seconds, not hours.