ITKokka
Lesson 7 · Note 12

Why Use Charts?

📌 The Short Note

Download

📖 Explanation

Why Use Charts?

Charts are visual representations of data. They turn numerical information into a form that is easier to understand, compare, and analyse. In a spreadsheet, charts are commonly created from values stored in a worksheet.

A chart can help a reader recognise differences between categories, follow changes over time, understand how parts contribute to a whole, and identify relationships between two numerical variables.

This note explains why charts are useful and introduces five common chart types: column, bar, line, pie, and XY scatter charts.

Why Are Charts Used?

Charts present data visually instead of requiring the reader to study a table of numbers. A well-chosen chart can communicate important information quickly.

Common uses of charts include:

  • Presenting numerical data visually: A chart converts worksheet values into bars, lines, slices, or plotted points.
  • Comparing values: It is easier to see which category has a higher or lower value.
  • Identifying patterns and trends: A chart can reveal increases, decreases, and repeated patterns.
  • Supporting analysis and decisions: Charts help readers interpret information and communicate findings in reports and presentations.
  • Showing parts of a whole: Some charts show how individual categories contribute to a total.

For example, a table of monthly sales can be converted into a column chart. The chart makes it easy to identify the month with the highest sales and compare sales between months.

Example: Monthly Sales
MonthSales (Rs.)
January4,000
February6,000
March5,000
April8,000
May7,000

A chart based on these values shows that April has the highest sales, while January has the lowest sales.

Types of Charts

Different chart types are suitable for different kinds of data and purposes. Selecting the correct chart helps prevent the information from being misunderstood.

1. Column Chart

A column chart uses vertical rectangular bars called columns. The height of each column represents the value of a category.

Column charts are useful for:

  • Comparing values among different groups or categories.
  • Showing changes across a period of time.
  • Identifying the highest and lowest values quickly.
Example: Number of Students in Clubs
ClubNumber of Students
IT25
Music40
Sports30
Drama20

A column chart displays one vertical column for each club. The Music Club has the highest number of students, while the Drama Club has the lowest.

Remember: Column charts use vertical bars.

2. Bar Chart

A bar chart uses horizontal rectangular bars to represent values. The length of each bar corresponds to the value of its category.

Bar charts are useful for:

  • Comparing values among categories.
  • Presenting category names that are long.
  • Making differences between groups easy to see.
Example: Book Sales
Book TypeSales (Rs.)
Fiction5,000
Science3,000
History4,000
Comics6,000

The horizontal bars make it easy to compare sales. Comics have the highest sales, while Science has the lowest.

Remember: Bar charts use horizontal bars, whereas column charts use vertical bars.

3. Line Chart

A line chart displays data points connected by straight lines. It is especially useful for showing how values change over time.

Line charts can help identify:

  • Increasing or decreasing trends.
  • Changes between consecutive time periods.
  • Patterns in data collected at regular intervals.
Example: Monthly Temperature
MonthTemperature (°C)
January28
February30
March32
April31
May29

A line chart shows the temperature rising from January to March and then falling from March to May. This makes the trend easier to recognise than reading each value separately.

Remember: Line charts are commonly used to show changes and trends over time.

4. Pie Chart

A pie chart is a circular chart divided into sections called slices. Each slice represents a category's share of the total.

Pie charts are useful for:

  • Showing how a total is divided among categories.
  • Comparing proportions or percentages.
  • Understanding the contribution of each category to the whole.
Example: Website Traffic
Traffic SourcePercentage
Search40%
Social Media25%
Direct20%
Referral15%
Total100%

In this example, Search contributes 40% of the website traffic, making it the largest share. Referral contributes 15%, the smallest share.

A pie chart is most useful when the categories represent parts of one total. The percentages should add up to 100% when the chart represents the complete whole.

Remember: Pie charts show percentages or proportions of a whole.

5. XY Scatter Chart

An XY scatter chart displays individual points on a grid. Each point represents a pair of numerical values:

  • An X-value, plotted along the horizontal axis.
  • A Y-value, plotted along the vertical axis.

Scatter charts are useful for examining the relationship between two numerical variables. They can help identify patterns, correlations, or trends.

Example: Study Time and Test Marks
Study Time (hours)Test Marks
150
260
370
480
590

In this example, study time is the X-value and test marks are the Y-value. The plotted points move upwards as study time increases, showing a positive relationship in this example.

A positive relationship means that higher values of one variable tend to occur with higher values of the other variable. A scatter chart can also reveal a negative relationship or no clear relationship.

Remember: An XY scatter chart shows the relationship between two numerical variables.

Comparing the Chart Types

Chart typeAppearanceMain purpose
Column chartVertical barsCompare categories or show changes over time
Bar chartHorizontal barsCompare categories, especially with long labels
Line chartPoints joined by linesShow changes and trends over time
Pie chartCircular slicesShow percentages or parts of a whole
XY scatter chartIndividual points on X and Y axesShow the relationship between two numerical variables

Choosing a Suitable Chart

The chart should match the type of information and the purpose of the presentation.

  • Use a column chart to compare values across categories using vertical bars.
  • Use a bar chart to compare categories using horizontal bars, especially when category labels are long.
  • Use a line chart to show how a value changes over time.
  • Use a pie chart to show how categories contribute to a total.
  • Use an XY scatter chart to investigate the relationship between two numerical variables.

A chart that does not match the data may make comparisons difficult or give readers the wrong impression. Consider what the reader needs to understand before selecting a chart type.

How Charts Support Data Analysis

Charts help people move from raw data to useful observations.

For example, a school can use a column chart to compare the number of students in different clubs. A business can use a line chart to examine monthly sales trends. A website owner can use a pie chart to show the percentage of visitors from different sources.

Exam-Focused Points

Key Idea: Charts present numerical data visually and make it easier to compare values, analyse information, and identify patterns.

Key Idea: Column charts use vertical bars, bar charts use horizontal bars, and line charts use connected data points to show trends over time.

Key Idea: Pie charts show parts of a whole, while XY scatter charts show the relationship between two numerical variables.

Students should be able to identify each chart type from its appearance and explain its main purpose. In questions that ask which chart is most suitable, pay attention to whether the task is comparing categories, showing a trend, displaying percentages, or examining a relationship.

Summary

Charts convert worksheet data into visual information. They make comparisons easier, help reveal patterns and trends, and support clear communication.

  • Column chart: compares values using vertical bars.
  • Bar chart: compares values using horizontal bars.
  • Line chart: shows changes and trends over time.
  • Pie chart: shows percentages or parts of a whole.
  • XY scatter chart: shows the relationship between two numerical variables.

Choosing a chart according to the data and the purpose of the presentation makes spreadsheet information easier to understand and analyse.

Share:
← Absolute Cell ReferencesCreating a Chart →