Skip to main content

How to make a graph in Excel

If you use Excel regularly for studying or work that requires a spreadsheet to be filled with data-driven information, then you know it can be quite difficult and time-consuming to decipher -- even more so for those who are not familiar with analytical-based data.

Whether spreadsheets are complicated or not, the fact remains that graphs help break down your data into an easier to understand format, enhancing the general readability of your Excel spreadsheet.

Here’s how to make a graph in Microsoft Excel.

Difficulty

Easy

Duration

5 minutes

What You Need

  • Microsoft Excel

  • PC

Inserting a graph in Excel

Step 1: You’ll need to add your data into the Excel spreadsheet, with each column having its own dedicated title.

In the first screenshot of our instructions (see a few steps below) , we have entered a sample for demonstration purposes.

Step 2: Next, you’ll need to select the cells that contain all the data you wish to populate your graph with.

Step 3: Microsoft Excel provides a convenient feature that allows you to select from a number of templates for the graph. Click the Insert tab and then select Recommended charts.

Click a graph template of your choice and click OK.

The Recommended Charts window in Excel for selecting a graph style.
Image used with permission by copyright holder

Step 4: You can now customize the graph by changing its title (double-click Chart title), adjusting its size, its colors, etc.

With your new graph selected, select one of the following icons that appear next to it to customize your chart further:

  • Plus-sign icon: To add or take away various chart elements like its labels or legend.
  • Paintbrush icon: To change the color scheme or style of your graph.
  • Filter icon: You can use this narrow down which data gets to be featured in your chart.
The customization options for a graph in Microsoft Excel.
Image used with permission by copyright holder

Step 5: For a complete list of all the graph types you can apply, click the All charts tab in the window that appears when you select the Recommended charts option from step 3. For example, you can select the Bar or Line charts, with each offering its own set of designs (3D, Clustered, Stacked, and more).

The All Charts window in Microsoft Excel.
Image used with permission by copyright holder

Step 6: If you wish to change the graph type after choosing one, simply choose the Chart design tab from the ribbon at the top of your screen and then select the Change chart type button.

(The Chart design tab usually only appears once your current chart is selected. So select your current chart first and then navigate to the Chart design tab that appears at the top of your screen.)

The Change Chart Type button in Microsoft Excel.
Image used with permission by copyright holder

Step 7: You can also select a graph type from all the options within the section adjacent to the Recommended charts button on the Insert tab. Clicking the drop-down arrow next to each chart icon and hovering over a thumbnail contained within the menu that appears will show you a preview of what your chart will look like with that specific design.

The drop-down menu for a specific graph type in Microsoft Excel.
Image used with permission by copyright holder

Editors' Recommendations

Zak Islam
Computing Writer
Zak Islam was a freelance writer at Digital Trends covering the latest news in the technology world, particularly the…
How to draw in Microsoft Word
Drawing tools and a laptop.

Microsoft Word has features for inserting images and illustrations. But if you want to create your own picture or sketch, you need to know how to draw in Microsoft Word.

This guide will walk you through using Word's shapes, freeform drawing, and built-in drawing tools.

Read more
How to factory reset Windows 10 or Windows 11
Windows 10 Home vs. Pro

If you’re dealing with a sluggish or unresponsive computer, you may be close to just giving up. While your misery is understandable, don’t throw in the towel just yet. Before you ditch your computer and spend hundreds, or even thousands, of dollars on a new one, there’s one last trick that can save you time and money: A factory reset.

Follow the steps below to easily and successfully reset your Windows 10 or 11 PC to its clean factory setting. And if you're running into regular slowdowns, check out our guide on how to speed up Windows, too.
First, back up your computer
Before you reset your system, you’ll want to back up important information that you don’t want to lose. This includes documents, photos, music, and movies, but there are other items to back up as well. Make sure that you know all of your saved passwords, export all of your browser bookmarks, and have installation files for all the software you’ll want to reinstall -- or know where to get them.
Also, make sure you back up app-specific data, like custom filters saved in a photo utility, save files from your favorite games, and back up emails if using an offline client.

Read more
How to use ChatGPT to write Excel formulas
A laptop opened to the ChatGPT website.

Not everyone is an Excel spreadsheet expert and you may not always know how to write the formulas you need for a given data set. If you're having trouble figuring out the right formula for your data and computation needs, there's a new option that can help you write up that formula in just a few steps.

That option is ChatGPT, the buzzy, new AI chatbot from artificial intelligence company OpenAI. And among everything else ChatGPT can do, it can also write Excel formulas. In this guide, we'll show you how to use it to get the Excel formulas you need. Let's get started.

Read more