How to Insert an Excel Chart

Excel Charts thumbnail

You have never created an Excel chart before?

And you want to know how to start?

Then this is the perfect tutorial for you. In this article, I will show you how to insert charts in Excel.

Here’s an Excel sheet with some data in it

Here’s a sheet with some data in it.

Let’s say that I would like to create several charts to visualize the data in a better way. How can I do that?

First of all, I’ll select the data that I’d like to include in a chart and will click on the Insert tab.

Click on the Insert tab after selecting the data that has to be included in the chart

Here you can see the “Charts” section, where we have a number of chart buttons.

The

Microsoft Excel 2016 is really great because it includes the “Recommend Charts” functionality, which will suggest us several types of charts that are likely to represent well the data that we have selected.

Recommended charts feature in Excel is really useful

Clicking on “Recommended charts”, we’ll be shown a set of charts that will best fit to our data according to Excel.

And here we are. We have a column chart, a bar chart, a line chart, and a pie chart. Pretty much the four basic, traditional types of charts that we can have.

I’ll select the line chart and will click “Ok”.

Here is a ready chart inserted in Excel

Our chart is ready.

If we change our mind and decide that we would like a different chart, we can always click the “Change Chart Type” button and select the type of chart that we would like. There are a lot of options.

Switching to different chart type in Excel is easy

The right side of the window provides us with a small preview of the chart that we are about to select.

Excel shows right-hand side preview of the chart that we are about to select

This is how a column chart would look like.

This is how a column chart would look like

And this is how a bar chart would look like.

This is how a bar chart would look like

There are a lot of options that we can select from. The important thing is that you pick the one that best describes the data that you are working with.

This is how we insert charts in Excel. In our next post, we’ll learn how to modify an existing chart in Excel.

Thanks for sticking until the rest of the article!

Financial Auditing: Ultimate Guide

Financial auditing entails producing an opinion on the truth and fairness of the financial statements of a company. Only

Financial Auditing: Ultimate Guide

Financial auditing entails producing an opinion on the truth and fairness of the financial statements of a company. Only licensed accounting professionals (auditors) authorized by the relevant governing bodies for the territories they operate in can carry out the auditing of financial statements. Audits were first regulated with the...
Learn More

Clearinghouses and Custodians: Financial Intermediaries 101

Intermediaries are vital for a well-functioning financial system and allow their clients to solve the problems they face more

Clearinghouses and Custodians: Financial Intermediaries 101

Intermediaries are vital for a well-functioning financial system and allow their clients to solve the problems they face more efficiently than they could by themselves. We find several types: Brokers, Exchanges, and Alternative trading systems Dealers and Securitizers Depository Institutions Insurance Companies Arbitrageurs, and Clearinghouses and Custodians We shall...
Learn More

Long and Short Positions: Guide to Wall Street Lingo

Rather than an instance of duration, long and short positions are a reference to haves and have-nots. They touch

Long and Short Positions: Guide to Wall Street Lingo

Rather than an instance of duration, long and short positions are a reference to haves and have-nots. They touch on securities an investor really owns versus securities an investor owes. Basically, the terms “short” and “long” denote what “selling” and “buying” do respectively. Featured: What is a Long Position?...
Learn More