Skip main navigation

Pie Charts and Bar Charts

Pie Charts and Bar Charts are useful methods for displaying the distribution of qualitative data. Adrian explains their use and interpretation here.

Do we want to know how different products contribute to profit? Then a pie chart might be the answer. Do we want to know how many sales we had for different salespersons? Then a bar chart might be the answer.

These are just two easy examples of when a pie or bar chart can provide a quick and effective description of your data. In this video, Adrian talks about these types of charts and how they can be used. You’ve probably seen them before, though, as there are so many questions they are helpful for.

Let’s discuss

In the comments below, share an example of when you may use a pie chart vs a bar graph in your own work or study.

Soon we’ll step through how we made these charts in Microsoft Excel. For now, if you are comfortable with these two charts, let’s move on to start learning about Histograms.

This article is from the free online

Data Analytics for Decision Making: An Introduction to Using Excel

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education