How to Make a Chart in Excel from a Table

Turning a table full of numbers into a clear, compelling chart is one of the most powerful features in Excel. A good chart can instantly reveal trends, highlight comparisons, and tell a story that raw data simply can't. This guide will walk you through everything you need to know, from preparing your data to customizing your chart to look professional and publication-ready.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First Things First: Prepare Your Data Table

Before you click a single button in Excel's chart menu, the success of your visualization depends entirely on the data you give it. A clean, well-structured table is the foundation of a great chart. Messy data leads to confusing, incorrect charts that don't make sense. Spend a minute getting this part right, and the rest of the process will be smooth sailing.

Keep Your Table Structure Simple

Good charts come from simple tables. For most common charts, you want your data organized in straightforward columns and rows.

• Your first column should typically be your labels or categories (e.g., Months, Product Names, Marketing Channels).
• Subsequent columns should contain the numerical data you want to plot (e.g., Sales, Website Visitors, Conversion Rates).

Here’s an example of a simple, well-structured table ready for charting:

Use Clear, Concise Headers

Excel uses the header row of your data table to automatically generate axis titles and legend entries. Make them clear and descriptive. Instead of "Rev," use "Revenue." Instead of "M1," use "January." This makes your chart instantly understandable without forcing your audience to decipher cryptic labels.

Avoid Blank Rows and Columns

Blank rows or columns inside your data range can confuse Excel. When it encounters a completely empty row or column, it often assumes the dataset has ended. This can lead to your chart only displaying a portion of your data. Before creating your chart, do a quick scan and delete any empty rows or columns that are breaking up your table.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Choosing the Right Chart for Your Data

Excel offers what can feel like an overwhelming number of chart types. While it might be tempting to pick the most colorful or complex-looking one, the best choice is always the one that communicates your message most effectively. Here are the four most common types and when to use them.

1. Column or Bar Chart

When to use it: When you need to compare discrete categories against each other. A column chart (vertical bars) is the standard go-to for this.

• Comparing sales figures across different products.
• Showing website traffic from various marketing channels.
• Displaying survey responses for a multiple-choice question.

Pro-Tip: Use a horizontal bar chart when you have long category labels that would be difficult to read if they were slanted on the X-axis of a column chart.

2. Line Chart

When to use it: To show a trend or measure change over a continuous period of time. Line charts are perfect for illustrating how a value has increased or decreased.

• Tracking monthly revenue over a year.
• Plotting website sessions on a daily basis.
• Showing stock price fluctuations over time.

3. Pie Chart

When to use it: To show the parts of a whole, where a single data series totals 100%. Pie charts work best when you have just a few distinct categories.

• The percentage breakdown of an ad budget across different platforms.
• Market share distribution among a few competitors.

Friendly Warning: Pie charts get a bad rap for good reason. They become very difficult to read once you have more than 5 or 6 slices. If you have many categories, a column or bar chart is almost always a better, clearer choice.

4. Scatter Plot (XY Chart)

When to use it: To show the relationship or correlation between two different numerical variables.

• Does advertising spend correlate with an increase in sales?
• Is there a relationship between temperature and ice cream sales?
• Comparing a salesperson's calls made versus deals closed.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Guide to Making Your Chart

Okay, your data is clean, and you have an idea of the chart type you want. Let's build it.

Step 1: Select Your Data

Click and drag your mouse to highlight the range of cells you want to include in the chart. Make sure you include the header row and column, as Excel will use these for labels. It's important to select only the data. Don't include the grand total row if you have one, as it will often skew the scale of your chart and dwarf the other data points.

Step 2: Go to the "Insert" Tab

At the top of the Excel ribbon, click on the Insert tab. You'll see a section in the middle labeled "Charts."

Step 3: Choose Your Chart Type

Excel gives you two primary options here:

• Recommended Charts: This is a great feature for beginners. Based on your data structure, Excel will suggest a few chart types that are likely a good fit. It's often a good place to start, as it can suggest options you might not have considered.
• Specific Chart Icons: If you know exactly what you want, you can click the icon for a column, line, pie, or other chart type. Clicking the icon will reveal a dropdown with different 2-D, 3-D, and other variations of that chart.

Once you click on a chart type, Excel will instantly create and place the chart right on your spreadsheet a few cells from your table.

Customizing Your Chart to Make it Look Great

Excel's default charts are functional, but a few tweaks can elevate them from basic to professional. When you select your chart by clicking on it, two new contextual tabs will appear on the ribbon at the top of the window: Chart Design and Format.

Another way to customize specific elements is to use the plus (+) sign that appears to the upper-right of your selected chart. This icon opens the "Chart Elements" menu, a quick way to add or remove key components.

Adding and Modifying Titles and Labels

Every chart needs a clear title.

• Chart Title: Your chart is an image that will likely be copied into a presentation or email. It needs a descriptive title so anyone can understand its purpose at a glance. Double-click the default "Chart Title" text to edit it.
• Axis Titles: It's critical to label your X and Y axes. If the Y-axis shows a number, is it revenue in dollars? Units sold? Percentage change? Use the Chart Elements (+) menu to add Axis Titles and then double-click them to add your text.

Changing Colors and Styles

Stuck with the default blue? The Chart Design tab has you covered.

• Chart Styles: This is a gallery of pre-set designs that change the background color, gridlines, font effects, and more with a single click. It's a fast way to find a professional-looking style.
• Change Colors: This dropdown provides curated color palettes that work well together. You can choose from colorful or monochromatic options to match your company's branding. To change an individual bar or slice, double-click on that specific element to open the Format pane, then use the "Fill" option to select a custom color.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Working with Data Labels and the Legend

Sometimes, putting the numbers directly on the chart is clearer than making someone guess the value from the axis.

• Data Labels: Use the Chart Elements (+) menu to add Data Labels. You can choose to place them inside the bar, outside, at the center, and so on. This puts the exact numerical value on each data point.
• Legend: If you have multiple data series (e.g., you're plotting "Revenue" and "Profit" over time on the same line chart), you need a legend to tell the reader what each line or color represents. This is usually on by default, but you can move its position (top, bottom, right, left) or toggle it off from the Chart Elements menu.

Pro Tip: Create a Combination Chart

What if you want to show two very different types of data on the same chart? For example, plotting monthly sales in dollars (which may be in the tens of thousands) and the number of units sold (which may be in the hundreds).

If you plot these on a standard column chart, the units sold bars will be tiny and almost invisible next to the huge revenue bars. The solution is a combination chart with a secondary axis.

1. Create a normal clustered column chart with both data sets.
2. Right-click on one of the series you want to change (e.g., the "Units Sold" bars).
3. Select "Change Series Chart Type..."
4. In the dialog box, you'll see both of your data series. Change the chart type for "Units Sold" to a Line chart and, most importantly, check the box next to it that says "Secondary Axis."

Excel will add a new Y-axis on the right side of your chart scaled for units sold, plotting that data as a line chart that overlays your revenue columns. This is a powerful way to show relationships between two different data types on a single chart.

Final Thoughts

Creating charts from a table in Excel is a straightforward skill that can transform how you present and interpret data. By focusing on a clean data structure, choosing the right chart type for your message, and using customization options to add clarity, you can present professional-grade visuals that everyone can understand.

While mastering Excel charts is valuable, we know it’s often just one of the many manual reporting steps you repeat every week. We built Graphed because we believe there’s an easier way. Instead of downloading CSVs and building the same charts repeatedly, you can connect your data sources directly and ask for the charts you need in plain English. Your dashboards then update in real-time, giving you hours back to focus on strategy, not spreadsheet-wrangling.