Skip main navigation

£199.99 £139.99 for one year of Unlimited learning. Offer ends on 28 February 2023 at 23:59 (UTC). T&Cs apply

Find out more

Using Excel to Create Graphs

In this article, the importance of being able to construct visualisations for your own data is discussed.
man working on computer at a desk
© Bond University

In the last activity, we addressed the ‘what’ and the ‘why’. You now know what some common and useful graphical techniques are and you also know why we use them. These are important for engaging with and critically assessing data analysis, but you also need to know how to create them.

Now, in this activity, you’ll learn how to construct them yourself. We’ll be revisiting the examples shown and going through their creation step-by-step. Unfortunately, FutureLearn doesn’t support the sharing of Excel files within the comments. If you have your own data available, however, we’d suggest you try experimenting and following along.

You can share your work with other learners and view examples from others on this course using our Padlet wall here. Please do not share inappropriate materials or any personally identifiable information, learners who do so will have their posts removed.

Actively doing a task helps to reinforce the lessons and ensures you get the most out of this activity. If you don’t have access to Microsoft Excel, you could also use the free Google Sheets.

If you’re ready, Mark as Complete and move on to next step to get started with pie charts and bar charts.

© Bond University
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