How to Create a Graph in Excel

Turning spreadsheets full of numbers into a visual story is what graphs are all about, and Excel is one of the most common tools for the job. But going from a raw data table to a clear, professional-looking chart can feel a little intimidating. This guide breaks down exactly how to create a graph in Excel, from getting your data ready to customizing your chart 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

First, Prepare Your Data for Graphing

Before you even think about charts, the single most important step is to make sure your data is organized properly. A clean data set is a happy data set, and it prevents 99% of common graphing headaches. Excel is smart, but it needs your data to be structured logically.

Follow these quick rules to set yourself up for success:

• Use Column Headers: Make the first row of your selection your headers. These labels (e.g., "Month," "Sales," "Website Visitors") will automatically be used to create chart labels and the legend, saving you time.
• One Row, One Record: Each row should represent a single entry or data point. For example, a row for January's sales, a row for February's sales, and so on.
• Keep Data Types Consistent: Ensure each column contains the same type of data. The "Date" column should only have dates, and the "Revenue" column should only have numbers. Mixing text and numbers in the same column will confuse Excel.
• No Blank Rows or Columns: Keep your data in a single, contiguous block. Don't leave empty rows or columns in the middle of your dataset, as this can cause Excel to misinterpret where your data range ends.

Here’s a look at an ideal data structure. It's simple, clean, and ready to be graphed.

Example of a well-structured data set:

Notice how the headers are clear, each month is on its own row, and the data is consistent. This is the perfect foundation.

Choosing the Right Type of Graph

Once your data is clean, the next step is deciding which kind of chart best tells your story. Using the wrong chart type can obscure your insights or even mislead your audience. Excel offers a huge variety, but you can cover most business needs with just a few core types.

Column or Bar Charts

When to use them: Comparing values across different categories.

Column charts (vertical bars) and bar charts (horizontal bars) are the workhorses of data visualization. They are excellent for comparing distinct items, like sales figures for different products, headcount for each department, or showing follower counts across social media channels.

• Pro-tip: Use a standard column chart for a handful of categories. If you have many categories or long category labels, switch to a bar chart to give your labels more room to breathe.

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

Line Charts

When to use them: Showing trends over a continuous period of time.

If you want to track changes over days, months, quarters, or years, a line chart is your best friend. It’s perfect for visualizing things like website traffic over the year, stock prices, or monthly revenue figures. The upward or downward slope of the line makes trends instantly visible.

Pie Charts

When to use them: Displaying the composition or parts of a whole.

Pie charts are used to show percentages. For example, you might use one to display the percentage of your budget allocated to different departments or the market share held by competitors. They work best when you are showing how a single total is broken down into its key components.

• Word of caution: Pie charts become very difficult to read with more than 5 or 6 slices. If you have too many categories, viewers will struggle to compare the sizes of the wedges. In that case, a bar chart is a better option.

Scatter Plots (XY Charts)

When to use them: Showing the relationship between two different numerical variables.

Are you wondering if your ad spend is related to your website conversions? Or if temperature affects ice cream sales? A scatter plot can help you spot potential correlations. Each dot on the chart represents a single data point with two numeric values (one for the X-axis and one for the Y-axis). The pattern of the dots can reveal a relationship (positive, negative, or no correlation).

Combination Charts

When to use them: Visualizing two different types of data on the same chart.

Sometimes you need to show two very different metrics that have different scales. A combo chart lets you layer two chart types, like a column chart and a line chart, on top of each other. This is great for showing monthly sales revenue (in columns) against the customer satisfaction score (as a line). It allows for richer insights from a single visual.

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-by-Step: Creating Your Graph in Excel

Now for the main event. Let’s walk through the process of creating a basic graph using our simple monthly sales data above.

Step 1: Select Your Data

Click and drag your mouse to highlight the cells that contain the data you want to graph. Be sure to include the column headers in the top row and row headers in the first column, as Excel will use these to label your chart automatically.

Step 2: Go to the 'Insert' Tab

With your data highlighted, navigate to the Excel ribbon at the top of the screen and click on the Insert tab.

Step 3: Choose a Chart Type

In the middle of the 'Insert' tab, you’ll find the 'Charts' group. You have two main options here:

• Recommended Charts: This is a great starting point for beginners. Excel will analyze your selected data and suggest a few chart types that it thinks are most appropriate. Click this button to see a few options and choose the one that looks best.
• Select a Specific Chart: If you already know which type you want, you can click on its icon directly. You’ll see icons for Column, Line, Pie, and Bar charts, and more. Hover over an icon to see the different sub-types available (e.g., 2-D Column, 3-D Column, Stacked Column).

For our example, a column chart is a good fit. We’ll select the first option, a simple 2-D Clustered Column chart.

Step 4: Your Chart Appears!

Once you select your chart type, Excel will instantly create the graph and place it on your worksheet. And just like that, you have a basic chart! But we're not done yet. The next step is making it look polished and professional.

Customizing Your Graph for Clarity and Impact

A good chart isn't just created, it's refined. The default Excel settings get you started, but to truly tell a clear story, you need to customize the key elements. When you click on your new chart, two new tabs will appear on the ribbon: Chart Design and Format.

Add and Edit Chart Elements

One of the easiest ways to customize is by using the plus symbol (+) that appears in the top-right corner of the selected chart. Clicking it opens the 'Chart Elements' menu, where you can easily add, remove, or modify components.

Changing the Chart Title

The default title is often generic ("Chart Title"). Click on it directly to type in a new, more descriptive title like "Monthly Sales Performance - Q1 2024". A good title tells your audience exactly what they’re looking at.

Adding Axis Titles

What do the numbers on the vertical (Y) and horizontal (X) axes represent? Don't make your audience guess. Click the '+' button next to the chart, check the box for Axis Titles, and then edit the placeholder text to be specific (e.g., "Revenue ($)" for the Y-axis and "Month" for the X-axis).

Including Data Labels

To show the exact value of each bar, point, or slice, check the Data Labels box. This adds the numerical data directly onto the chart, which can prevent viewers from having to estimate values by looking back and forth between the chart and the axes.

Adjusting the Legend

The legend helps viewers understand what each color or pattern represents, which is critical when you have multiple data series (e.g., graphing both "Units Sold" and "Revenue"). You can use the menu to move it to the top, bottom, left, or right of the chart for better placement.

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

Changing the Style and Colors

In the Chart Design tab, you can quickly change the entire look and feel of your graph.

• Chart Styles: This is a gallery of pre-made designs. Browse through and click to apply different visual styles that include various color schemes, shadows, and outlines.
• Change Colors: Click this button to apply a different color palette. You can choose from a range of professionally designed palettes or create your own to match your company's branding.

Pro-Tips for Excellent Graphs

Creating a chart is easy. Creating a chart that's effective requires a little more thought. Here are a few final tips to elevate your charts from basic to brilliant.

• Keep It Simple: Avoid "chart junk." Don't add 3D effects, gradients, or shadows just because you can. An overloaded chart is a confusing chart. The goal is clarity, not artistic flair.
• Let Your Data Tell One Story: Every chart should have a single, clear message. If you find yourself trying to show too many things at once, consider splitting your data into two separate charts.
• Sort Your Data: For bar and column charts, sorting your data from largest to smallest (or vice versa) can make a huge difference. This simple step makes it much easier for viewers to see rankings and quickly identify top performers.
• Be Mindful of Your Axes: For column and bar charts, the vertical axis scale should almost always start at zero. Starting it higher can distort the proportions between the bars and mislead the viewer about the magnitude of differences.

Final Thoughts

Mastering chart creation in Excel transforms you from someone who just collects data into someone who can communicate insights effectively. By focusing on clean data preparation, choosing the right chart for your message, and adding clear customizations, you can build graphs that are both informative and compelling.

While Excel is a fantastic tool for manual analysis, the process of downloading CSVs, cleaning them, and building reports can eat up hours every week. At Graphed, we automate all of that. We help you connect directly to data sources like Google Analytics, Shopify, and Facebook Ads, so you can build real-time dashboards using simple, plain English. Instead of manually building charts, you can just ask questions and get live, interactive visualizations back in seconds.