How to Turn Excel Data into a Chart

Turning a spreadsheet packed with numbers into an insightful chart can feel like a chore, but it's one of the best ways to understand and communicate your data. This guide walks you through the entire process, from structuring your data correctly to customizing your charts for maximum impact.

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 Visualizing Data in Excel?

While tables of numbers are precise, they aren't great for spotting patterns at a glance. Visualizing your data with charts helps in several key ways:

• It makes data easier to understand. Our brains process visual information much faster than text. A line chart showing an upward trend is instantly understood, while figuring that out from raw numbers takes time and effort.
• It helps you spot trends and outliers. Is your revenue growing month-over-month? Did one marketing campaign perform significantly better than others? Charts make these insights pop off the page.
• It tells a more compelling story. Presenting a report to your team or a client is far more effective with a clear chart that backs up your points. It provides immediate context that numbers alone can't.

Step 1: Get Your Data Ready for Charting

Before you even think about clicking the "Insert Chart" button, the single most important step is preparing your data. Clean, well-structured data is the foundation of a good chart. If your data is messy, Excel will get confused, and your chart will be misleading or just plain wrong.

Follow these simple rules for arranging your data:

• Give each column a clear header. Your top row should contain descriptive labels for the data below it (e.g., "Month," "Sales," "Website Traffic").
• Keep it in a simple tabular format. Think basic rows and columns. Avoid merging cells or leaving blank rows or columns in the middle of your dataset, as this can break the selection process.
• Ensure your data types are correct. Make sure numbers are formatted as numbers (not text) and dates are formatted as dates. If Excel thinks your sales figures are text, it can't plot them correctly.

For example, structure your data like this:

And not like this, which includes merged cells and unnecessary text that will confuse Excel:

Cleaning up your data first will save you a world of frustration down the road.

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: Create a Basic Chart in a Few Clicks

Once your data is clean and organized, creating the chart is surprisingly simple. Excel’s "Recommended Charts" feature does most of the heavy lifting for you.

1. Select your data. Click and drag your mouse to highlight the cells you want to include in the chart. Be sure to include the column headers in your selection.
2. Go to the Insert tab. In the Excel ribbon at the top, click on the "Insert" tab.
3. Click "Recommended Charts." You'll see this option in the "Charts" section of the Insert tab. Excel will analyze your selection and suggest a few chart types that best fit your data. For our "Units Sold" example, it would likely suggest a Column or Bar chart.
4. Choose a chart and click OK. A preview of each chart type is shown. Select the one that makes the most sense for your data, and click "OK" to insert it into your worksheet.

That's it! You now have a basic chart sitting right in your spreadsheet. Of course, the default chart is just the beginning. The real power comes from choosing the right type of chart and customizing it effectively.

Step 3: Choose the Right Chart for Your Data Story

Excel offers a huge variety of chart types, and picking the right one is crucial for telling a clear story. Using the wrong one can obscure your message or even mislead your audience. Here’s a breakdown of the most common chart types and when to use them.

Bar and Column Charts

Use them for: Comparing values across different categories. Bar charts (horizontal bars) and column charts (vertical bars) are arguably the most common and easy-to-read chart types. They are perfect for comparing distinct items. Use a column chart as the default, but switch to a bar chart if you have long category labels that are hard to read vertically.

Example: Comparing the number of units sold for several different products. Each product is a category, and the length of the bar represents the quantity sold.

Line Charts

Use them for: Showing a trend or changes over time. If you want to track how a value has changed, a line chart is your best friend. The X-axis (horizontal) is almost always a time period - like days, months, or years - while the Y-axis (vertical) represents the value you're tracking.

Example: Plotting your website's monthly traffic for the past year to see if your marketing efforts are leading to consistent growth.

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

Pie Charts

Use them for: Showing the composition or parts of a whole. Pie charts show how different categories contribute to a total, represented as percentages. However, use them with caution! They become very difficult to read if you have more than 4-5 "slices." Our eyes aren't good at comparing the size of angles, which makes it hard to see a difference between slices of similar sizes.

Example: Breaking down your sales by region, where each region (North, South, East, West) represents a percentage of total sales.

Scatter Plots

Use them for: Seeing the relationship or correlation between two different numerical variables. A scatter plot is perfect when you want to discover if one variable affects another. Each point on the chart represents one instance of your data with its X and Y values.

Example: Plotting your daily advertising spend against your daily revenue. You might see a positive correlation where days with higher ad spend also have higher revenue.

Combination Charts

Use them for: Displaying two different types of data on the same chart, often with different scales. Sometimes you need to show two different metrics that are related but measured in completely different units. A combination chart allows you to, for example, plot one series as a column chart and another as a line chart on a separate axis.

Example: Showing monthly revenue (in dollars, plotted as columns against the left axis) and the number of new customers acquired (a count, plotted as a line against the right axis).

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 4: Customize Your Chart for a Professional Look

A default chart gets the job done, but a well-customized chart makes you look like a pro. Fine-tuning your chart’s elements makes it easier to read and adds a professional polish.

When you click on your chart, two new tabs will appear in the Excel ribbon: Chart Design and Format. These are your control panels for customization.

Here are the key elements to focus on:

• Chart Title: The default "Chart Title" isn’t very helpful. Click on it and give your chart a descriptive name that tells the viewer exactly what they're looking at, like "Q3 Revenue by Product Category."
• Axis Titles: Are you measuring dollars, percentages, or units? Click the green "+" icon next to your chart and check "Axis Titles" to add labels for your horizontal and vertical axes so there’s no confusion.
• Data Labels: Sometimes it's useful to see the exact value for each data point on the chart itself. Use the "+" icon to add "Data Labels." This saves your audience from having to guess values based on the axis lines.
• Colors and Fonts: Use the Chart Design tab to quickly change the color scheme or style. For more control, right-click any chart element (like a specific bar or line) and select "Format Data Series" to change colors, add outlines, or adjust thicknesses individually. Keep it simple and use colors that are easy to distinguish.
• Legend: If you have multiple data series (e.g., a line chart showing sales for three different products), the legend is essential. You can move its position (top, bottom, right, or left) to find the spot that best fits your chart layout.

Final Thoughts

Creating charts in Excel is a powerful skill that transforms raw data into compelling visual stories. By starting with clean, organized data, choosing the right chart type and customizing it, you can create professional dashboards and reports that deliver clear insights.

Of course, much of this Excel work - especially downloading CSVs from different platforms like Google Analytics, Shopify, or Facebook Ads every week - is a manual and repetitive process. To help teams automate this, we built Graphed to connect directly to your marketing and sales data sources. You can use simple, natural language like "show me website traffic by source as a pie chart" to instantly create live, real-time dashboards, letting you get straight to the insights and giving you back the hours you'd otherwise spend wrestling with spreadsheets.