What Are the Steps to Create a Chart in Excel?

Turning rows and columns of data into a visual story is one of the most powerful features in Excel. A well-designed chart can reveal trends, highlight comparisons, and make your point in a way that raw numbers never can. This guide will walk you through the essential steps to create, customize, and master charts in Excel, transforming your spreadsheets into powerful communication tools.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

First Things First: Getting Your Data Ready for Charting

Before you even think about clicking the "Insert Chart" button, the success of your visualization depends entirely on how you've organized your data. A house built on a shaky foundation won't stand, and a chart built on messy data won't make sense. Following a few simple rules for data structure will save you a lot of headaches.

Your data should be arranged in a simple, logical format:

• Use Columns for Categories: Each column should represent a distinct category or variable. For example, you might have one column for "Month," one for "Sales Revenue," and another for "Marketing Spend."
• Use Rows for Individual Records: Each row should contain one complete record or data point. In our example, each row would represent a specific month and its corresponding sales and marketing numbers.
• Ensure Consistent Headers: Have a single header row at the very top. These headers will become the labels for your chart axes and legend, so make them clear and concise.
• Eliminate Blank Rows and Columns: Excel is smart, but it can get confused by empty rows or columns within your data range. This can cause it to select the wrong data or leave gaps in your chart. Make sure your data is in a contiguous block.

Here’s a look at an ideal data structure for charting:

With clean data like this, Excel can instantly understand the relationships and plot them correctly.

The 5 Core Steps to Create a Chart in Excel

Once your data is prepared, creating a basic chart is surprisingly straightforward. Let's walk through the process using our monthly sales data.

Step 1: Select Your Data

First, you need to tell Excel what information you want to visualize. Click on the top-left cell of your data set (including the header, like "Month") and drag your cursor to highlight the entire range you want to include in the chart. For our example, you would select everything from the cell containing "Month" down to the last data point.

Pro Tip: For large datasets, you can select the data more quickly. Just click on any cell within your data range and press Ctrl + A (or Cmd + A on a Mac). Excel will automatically select the entire contiguous block of data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Navigate to the Insert Tab

At the top of the Excel window, find the main ribbon with tabs like "Home," "Insert," "Page Layout," etc. Click on the Insert tab to reveal all the objects you can add to your worksheet, including charts.

Step 3: Choose Your Chart Type

In the middle of the Insert ribbon, you’ll find the Charts group. This section displays icons representing the most common chart types: column, line, pie, bar, and more.

If you aren't sure which chart is best for your data, Excel has a brilliant feature called Recommended Charts. Based on the structure of your selected data, Excel will suggest a few chart types that would be a good fit and show you a preview of how they'll look.

Otherwise, you can click on an icon to see the options within a specific category. For instance, clicking the column chart icon will show you options for 2-D columns, 3-D columns, 2-D bars, and 3-D bars.

Step 4: Your Initial Chart Appears

As soon as you select a chart type (e.g., a clustered column chart), Excel will instantly create the chart and place it on your worksheet. Don't worry if it doesn't look perfect yet! This is just your starting point. It will have a basic title, axes based on your data headers, and a simple color scheme.

Step 5: Customize and Refine Your Chart

This is where you turn a basic chart into an insightful, professional-looking visual. When you click on your new chart, two new tabs will appear on the ribbon: Chart Design and Format. These are your command centers for customization. We’ll cover these features in more detail below, but the key tools are located right next to the chart itself, often as three small buttons:

• Chart Elements (the '+' icon): Add, remove, or modify components like axis titles, a legend, data labels, and gridlines.
• Chart Styles (the paintbrush icon): Quickly apply professional design presets and color palettes.
• Chart Filters (the funnel icon): Temporarily hide or show specific data series or categories without having to change your underlying data table.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Common Chart Types and When to Use Them

Choosing the right chart type is essential for clear communication. Using the wrong one can confuse your audience or misrepresent your data. Here are the most common charts and their ideal uses:

Column or Bar Charts

When to use them: Use a column chart (vertical bars) or a bar chart (horizontal bars) when you want to compare different categories. They are excellent for showing discrete values like sales per product, website traffic by city, or survey responses.

Example: Comparing sales revenue for four different product lines in a single quarter.

Line Charts

When to use them: Line charts are the go-to choice for showing a trend over a continuous period. They are perfect for tracking data like monthly website sessions, stock prices over a year, or daily temperatures.

Example: Visualizing company revenue growth from January to December.

Pie Charts

When to use them: Use a pie chart to show the composition of a whole – in other words, how different parts make up 100%. They work best when you have just a few categories (ideally 5 or fewer) that are easy to distinguish.

Example: Showing the percentage of your marketing budget allocated to different channels (e.g., Google Ads, Social Media, Email).

Scatter (XY) Plots

When to use them: A scatter plot is used to see the relationship or correlation between two different numerical variables. Each point on the chart represents one observation with its value on the X-axis and Y-axis.

Example: Plotting advertising spend (X-axis) against its corresponding sales revenue (Y-axis) to see if higher ad spend leads to more sales.

Advanced Customization to Make Your Chart Shine

A default Excel chart gets the job done, but taking a few minutes to customize it can dramatically improve its clarity and impact.

Adding and Removing Chart Elements

Click on your chart, then click the green ‘+’ icon on the top right. A checklist of elements will appear.

• Axis Titles: Always add these! Labeling your X-axis (horizontal) and Y-axis (vertical) eliminates any guesswork for your audience. What do the numbers represent? Dollars? Percentages? Number of users?
• Data Labels: These add the exact numerical value on top of or next to each data point (each bar, line point, or pie slice). This is useful if you want to show precise numbers instead of having the viewer estimate from the axis.
• Legend: The legend explains what each color or pattern in your chart represents. It's automatically added when you have multiple data series (e.g., charting both "Sales Revenue" and "Units Sold") but can be repositioned or removed.
• Trendline: For line charts and scatter plots, a trendline adds a line that shows the general direction of your data, helping to visualize upward, downward, or flat trends.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Dialing in the Formatting

To access the deepest level of formatting for any chart element, just right-click on it (e.g., right-click on the vertical axis, a data series, or the chart title) and select Format [Element Name].... This will open up a detailed formatting pane on the right side of your screen.

From here, you can change almost anything:

• Adjust the font, color, and size of text.
• Change the fill color and border style of bars and areas.
• Set minimum and maximum values for an axis.
• Add shadows or glow effects for a more modern look (use with caution!).

Creating Dynamic Charts with Excel Tables

Here’s a common frustration: you create a perfect chart, but the next week you have to add new data, and the chart doesn't update. The solution is simple: turn your data range into an official Excel Table first.

1. Select your data range again.
2. On the Home tab, click Format as Table, or just press Ctrl + T.
3. Confirm that your data has headers and click OK.
4. Now, create your chart based on this Table.

Anytime you add a new row of data to the bottom of the table, your chart will automatically update to include it. It’s an easy trick that automates the process and ensures your visuals are always current.

Final Thoughts

Creating charts in Excel is a fundamental skill that transforms data from a list of numbers into a clear, compelling story. By focusing first on clean data preparation, then choosing the right chart type, and finally adding thoughtful customizations, you can build dashboards and reports that inform and persuade any audience.

Of course, the manual process of pulling data, cleaning it in a spreadsheet, and building charts can become incredibly time-consuming, especially when your data lives in different places like Shopify, Google Analytics, and Facebook Ads. This is exactly why we built Graphed. Instead of wrestling with CSVs and pivot tables, we let you connect your data sources in a few clicks. Then, you can create real-time, interactive dashboards just by describing what you want to see in plain English, getting back hours of your week to focus on strategy instead of report-building.