Making charts
In this section, we will focus on creating charts and diagrams derived from tabular data. Charts and diagrams are powerful tools that help us visualize and understand complex data. They provide a clear and concise representation of information, making it easier to identify trends, patterns, and relationships.
Chart 1: Sales Performance by Region
Let’s consider a hypothetical scenario where a company wants to analyse its sales performance across different regions. The company has collected data on sales revenue for the past year and wants to create a chart to compare the sales performance of each region.
| Here is the tabular data: Region | Sales Revenue (in millions) |
| Region A | 10 |
| Region B | 8 |
| Region C | 12 |
| Region D | 6 |
To create a chart from this data, we can use a bar chart. A bar chart is a type of chart that uses rectangular bars to represent data. Each bar represents a category, in this case, the regions, and the length of the bar represents the sales revenue.
To construct the bar chart, we will follow these steps:
- Draw a horizontal axis and label it “Region”.
- Draw a vertical axis and label it “Sales Revenue (in millions)”.
- On the horizontal axis, mark the regions: A, B, C, and D.
- On the vertical axis, mark the values: 0, 2, 4, 6, 8, 10, and 12.
- For each region, draw a rectangular bar starting from the horizontal axis up to the corresponding sales revenue value.
After following these steps, we will have a bar chart that visually represents the sales performance of each region. This chart will allow us to compare the sales revenue of different regions and identify any variations or trends.
Chart 2: Monthly Expenses Breakdown
Now, let’s consider another hypothetical scenario where a company wants to analyse its monthly expenses breakdown. The company has collected data on different expense categories for the past year and wants to create a chart to visualize the distribution of expenses.
| Here is the tabular data: Expense Category | Monthly Expenses (in thousands) |
| Salaries | 50 |
| Rent | 20 |
| Utilities | 10 |
| Marketing | 15 |
| Other | 5 |
To create a chart from this data, we can use a pie chart. A pie chart is a circular chart divided into sectors, each representing a proportion of the whole. In this case, the whole represents the total monthly expenses, and each sector represents an expense category.
To construct the pie chart, we will follow these steps:
- Draw a circle and label it “Monthly Expenses Breakdown”.
- Divide the circle into sectors proportional to each expense category. To calculate the angle for each sector, we can use the formula: (Monthly Expenses for a Category / Total Monthly Expenses) * 360 degrees.
- Label each sector with the expense category and its corresponding percentage of the total monthly expenses.
After following these steps, we will have a pie chart that visually represents the distribution of monthly expenses. This chart will allow us to easily identify the proportion of each expense category and understand the overall expense breakdown.
Charts and diagrams are valuable tools in data analysis and decision making. They provide a visual representation of complex data, making it easier to understand and interpret. By mastering the construction and interpretation of charts and diagrams, you will be equipped with a powerful skillset for informed decision making.