Creating a column chart is a great way to visually represent data so it’s easier to understand. A column chart is a type of bar chart that displays data using vertical bars. Each bar represents a category, and the height of the bar corresponds to the value or frequency of that category. Column charts are particularly useful for comparing different categories or tracking changes over time.
Now imagine you have a set of data, like the number of books you read each month. A column chart will help you see which months you read the most or the least. To create a column chart, follow these steps:
1 – Collect your data
First, gather the data you want to display. For example, you might have a list of the number of books you read from January to December (Figure 6).
2. Choose your tool
You can use graph paper and coloured pencils, or if you have a computer, software like Excel, Google Sheets, or even online chart makers.
3. Set up your chart
If you’re using paper, draw a large L-shape. The vertical line (y-axis) represents the number of books, and the horizontal line (x-axis) represents the months (Figure 7). Label each axis appropriately. If you’re using software, open a new spreadsheet and enter your data. For instance, put the months in one column and the number of books in the next column.
4. Drawn the columns
On paper, draw a column for each month, making the height of each column match the number of books read that month. In software, select your data and choose the column chart option from the menu. The software will create the chart for you.
5. Add details
Make sure to add a title to your chart, like “Number of books read per month,” and label each axis. You can also add colours to make your chart more visually appealing and easier to read. Figure 8 shows how the graph looks after applying all steps.
Now, let’s put this into practice!
Task: Create Your Own Column Chart
1. Think of something you can track for the next week. It could be the number of minutes you spend on homework, the number of times you practise a sport or play a game, how many chapters you read from a book each day…..
2. Write down your data each day for one week.
3. At the end of the week, use graph paper and coloured pencils or a computer to create a column chart. Label your x-axis with the days of the week and your y-axis with what you’re tracking (minutes, times, chapters, etc.).
4. Draw a column for each day, making sure the height matches your data. If you’re using a computer, enter your data and select the column chart option.
5. Add a title to your chart and any other details to make it clear and colourful.
6. Analyse your data. Can you find any trend or pattern?
By following these steps and completing the task, you’ll get hands-on experience in creating a column chart and understand how to use visual tools to interpret your data.
On the next chapter we will learn about Data and Accessibility.
I’m on YouTube now!
Check out Accessible BI for practical Power BI tutorials and tips on making data accessible to everyone. Subscribe here: Accessible BI YouTube Channel
[…] the next chapter is Creating a column chart, where you will be able to create your own data […]