Skip to main content

How to make a graph in Excel

how to make a graph on excel person looking at bar charts pc
yellowpicturestudio/Getty Images

If you use Microsoft 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. If you make a mistake with the column heading order, just redo or add a new column.

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. You can also alter the values in the table, and see how these impact the graph. If you don't want values to change, learn how to lock cells in Microsoft Excel.

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

Creating graphs is straightforward in Microsoft Excel. In fact, the process is so simple that other spreadsheet apps have more or less replicated it. So, it's one less thing to worry about if you can't make your mind up and are stuck trying to decide between Microsoft Excel and Google Sheets.

Zak Islam
Former Digital Trends Contributor
Zak Islam was a freelance writer at Digital Trends covering the latest news in the technology world, particularly the…
How to delete or hide chats in Microsoft Teams
Running Microsoft Teams on the Galaxy Tab S8.

Microsoft Teams is a terrific workplace platform for keeping the camaraderie strong. Featuring collaborative messaging, video conferencing, and file-sharing tools, it’s your one-stop-shop for in-office, hybrid and at-home workers alike. But anyone with a long history of using Microsoft Teams will tell you how clogged up your message stockpile can get. Fortunately, deleting and hiding these exchanges is relatively easy to do, and we’ve put together this guide to help.

Read more
The most common Microsoft Teams problems and how to fix them
A close-up of someone using Microsoft Teams on a laptop for a videoconference.

Microsoft Teams was introduced in 2017 as a unified communication and collaboration platform aimed at helping businesses and organizations get things done. Microsoft leveraged the company's existing Office software experience and created a unified experience between Teams, Office 365, and Skype for Business. However, as with all software, things don't always go according to plan. If you're using Microsoft Teams, sometimes you can run into problems.

We're big Teams users here at Digital Trends -- it's our go-to communication and meeting tool -- and we've come across a few issues ourselves over the years. In the event you're having Microsoft Teams issues, here's how to fix some of the most common problems.

Read more
How to keep your Microsoft Teams status active
Man uses Microsoft Teams on a laptop in order to video chat.

Keeping your Microsoft Teams status as "Active" can be a stressful experience if your boss is constantly looking over your shoulder. It might not be the most common Teams problem, but it's one we've all experienced at some point. While you might be getting on with something productive, if the person in charge doesn't know that and doesn't take kindle to "Busy" statuses, you may want to try some tricks to keep your status active when using Microsoft Teams.

Fortunately there are a number of ways you can do that, from the honest and transparent, to the slightly sneaky. No judgement here. You do what you need to do. We're just here to teach you how to keep your Team status active.

Read more