How to Generate Graphs in Excel

Creating a graph in Excel can turn a wall of numbers into a clear, compelling story in just a few clicks. If you've ever stared at a spreadsheet wondering how to make sense of it all, you're in the right place. This guide will walk you through everything from preparing your data to customizing your final chart, helping you build professional-looking graphs with confidence.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

First, Prepare Your Data

Before you create any graph, the most important step is setting up your data correctly. A well-organized table is the foundation of a clear chart. Messy data leads to a confusing graph, so a few minutes of cleanup upfront will save you a ton of headaches later.

Follow these simple rules for clean, graph-ready data:

• Use Headers: Put a unique, descriptive header at the top of each column. For example, use "Month" and "Revenue" instead of having data start in the first row. Excel uses these headers to create axis labels and legends.
• Keep it Consistent: Ensure each column contains the same type of data. The "Revenue" column should only have numbers (formatted as currency is even better), and the "Month" column should only have months.
• No Empty Rows or Columns: Keep your data in a single, contiguous block. Blank rows or columns in the middle of your dataset can confuse Excel when it tries to automatically select your data range.

Here’s what a simple, well-structured data table looks like:

With data organized like this, you're ready to start visualizing.

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

Once your data is prepped, creating a graph takes less than a minute. We'll use a basic column chart as our example, as it's one of the most common and versatile chart types.

1. Select Your Data: Click and drag your mouse to highlight the cells you want to include in your graph. Make sure to include your column headers. In our example, you would select the entire table from "Month" down to "$19,000".
2. Go to the Insert Tab: At the top of the Excel window, click on the Insert tab in the main ribbon.
3. Choose a Chart Type: In the middle of the Insert ribbon, you’ll find a section called Charts. You can either click on Recommended Charts to let Excel suggest a few options, or you can click on the icon for the specific chart you want – like the one that looks like a column chart. For this example, click the column chart icon and select a simple 2-D Clustered Column chart.

And that’s it! Excel will instantly place a new graph right onto your worksheet. Now comes the fun part: picking the right type of chart and making it look great.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Choosing the Right Type of Graph for Your Data

Excel offers a huge variety of chart types, and choosing the right one is essential for telling your data's story effectively. Using the wrong one can misrepresent your information or confuse your audience. Here’s a breakdown of the most common types and when to use them.

Column and Bar Charts

Best for: Comparing values across different categories.

Column charts (vertical bars) and bar charts (horizontal bars) are perfect for comparing distinct items. For example, you could use a column chart to compare monthly sales figures, website traffic from different social media platforms, or product sales by category.

Pro Tip: Use a bar chart (horizontal) when you have long category labels that are hard to read when placed vertically under columns.

Line Charts

Best for: Showing trends over a period of time.

A line chart is the go-to choice for tracking data points over a continuous period, like days, months, quarters, or years. Use it to visualize website sessions over the last 30 days, revenue growth year-over-year, or stock price changes. The upward or downward slope of the line immediately communicates trends.

Pie Charts

Best for: Showing the composition or proportions of a whole.

A pie chart breaks down a single total into its constituent parts. It’s ideal when you want to show percentages that add up to 100%. For example, you could use a pie chart to display the percentage of your marketing budget allocated to different channels (e.g., Google Ads, Facebook Ads, Email Marketing).

Friendly Warning: Use pie charts sparingly! They become difficult to read if you have more than 5 or 6 "slices." If you need to show the composition of something with many parts, a bar chart is often a clearer alternative.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Scatter Plots

Best for: Revealing the relationship between two different numerical variables.

A scatter plot (or XY chart) is used to determine if a relationship or correlation exists between two sets of data. For instance, you could plot daily ad spend versus daily sales to see if higher spending correlates with more sales. Each dot on the plot represents a paired data point (e.g., one day's spend and its corresponding sales).

Area Charts

Best for: Showing the magnitude of a trend over time, especially when comparing multiple series.

An area chart is similar to a line chart, but the area under the line is filled with color. This helps emphasize the volume or total over time. A stacked area chart can be particularly useful for showing how individual parts contribute to a whole over a period, such as tracking revenue contributions from different product lines each quarter.

Customizing Your Graph for a Professional Look

A default Excel chart is a great starting point, but with a few customizations, you can make it much clearer and more professional. When you click on your new chart, two contextual tabs will appear in the ribbon: Chart Design and Format. You'll also see three small icons appear on the right side of the chart itself.

Adding and Removing Chart Elements

Click the plus icon (+) on the right side of your chart to add, remove, or modify elements. Here are the most important ones to pay attention to:

• Chart Title: Your chart should always have a clear, descriptive title. Triple-click the default "Chart Title" text and type something more specific, like "Monthly Revenue - Q1 2024".
• Axis Titles: It's not always obvious what the horizontal (X-axis) and vertical (Y-axis) lines represent. Add axis titles to remove any ambiguity. For our example, the X-axis would be "Month" and the Y-axis would be "Revenue ($)".
• Data Labels: Check this box to display the exact value of each bar, slice, or point directly on the chart. This can save your audience from having to estimate values based on the axis.
• Legend: If your chart includes multiple data series (e.g., comparing sales figures for two different products over time), a legend is essential. It tells the viewer what each color represents.
• Trendline: For line charts and scatter plots, a trendline can help visualize the general direction of your data, making trends even more obvious.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Adjusting Style and Colors

Click the paintbrush icon to quickly change the visual style and color scheme of your graph. Excel offers several pre-designed themes, but you can also set your own colors.

To change the color of a single element (like one bar in your column chart), first click the chart to select the entire data series (all the bars), and then click that specific bar again to select it individually. Right-click it and choose Format Data Point, then go to the Fill options to select a new color.

Final Thoughts

Mastering graphs in Excel boils down to a few key principles: start with clean, well-organized data, choose the chart type that best tells your story, and customize the details to make your message sharp and clear. With these skills, you can transform intimidating datasets into powerful tools for communication and decision-making.

While Excel is fantastic, the process of exporting data from all your different platforms - like Google Analytics, Shopify, HubSpot, and your ad accounts - and then wrangling it in a spreadsheet can easily eat up your entire Monday morning. At Graphed you can connect all your data sources in one place and then build real-time dashboards and reports just by describing what you want to see. Instead of messing with CSV files and pivot tables, you can just ask, "Show me a line chart of my Shopify revenue vs. Facebook Ads spend for the last 90 days," and instantly get an answer.