Mada za sehemu hiiManaging spreadsheet and data presentationMada 4
- Managing components, worksheets and formatting
- Implementing conditions and data
- Implementing functions and formulas
- Implementing data visualisation with charts and tables
Implementing Data Visualisation with Charts and Tables
Data visualisation is the presentation of processed data in different visual forms that are easy to understand. In this topic, you will learn how to use tables and charts to present data effectively using spreadsheet software like Microsoft Excel.
A table is a set of rows and columns that helps you manage and present data. Tables make it easy to sort, filter, and analyze information.
Creating a Table from a Range
To convert a range of data into a table:
- Select the range of cells you want to convert (for example, A1:F22)
- Click Insert on the ribbon, then click Table
- Make sure "My table has headers" is checked if your first row contains column names
- Click OK
The range is now a table with special features like automatic filtering arrows and table styles.
Table Design Options
When you click on any cell in the table, the Table Design tab appears with useful options:
- Resize Table: Change the table's range
- Remove Duplicates: Delete repeated rows
- Convert to Range: Turn the table back into a regular range
- Style Options: Add total row, header row, or banded rows
Resizing a Table
You can make a table larger or smaller:
Using the Resize Command:
- Select any cell in the table
- Go to Table Design tab
- Click Resize Table
- Enter the new range (for example, A1:F20)
- Click OK
Using Drag:
- Click and hold the bottom-right corner of the table
- Drag to mark the new range
Removing Duplicates
To remove duplicate rows:
- Select a cell in the table
- Go to Table Design tab
- Click Remove Duplicates
- Choose which columns to check
- Click OK
Excel will show how many duplicates were removed and how many unique records remain.
Sorting arranges data in order—either from smallest to largest (ascending) or largest to smallest (descending).
Sorting a Single Column
- Select the column you want to sort
- Go to Home tab → Sort & Filter
- Choose Sort A to Z (ascending) or Sort Z to A (descending)
Sorting Multiple Columns
When your data has related columns, always sort all columns together:
- Select the entire data range
- Go to Sort & Filter → Custom Sort
- Add sort levels for each column
- Click OK
Important: If you sort only one column without selecting the rest, the data relationships will break and information will be mismatched.
Filters hide rows that do not meet certain criteria, helping you focus on specific data.
Applying Filters
- Make sure your first row contains headers
- Select the data range including headers
- Go to Data tab → Filter
Arrow buttons appear in each header cell.
Filtering by Criteria
- Click the arrow in the column header
- Uncheck the items you want to hide
- Check only the items you want to see
- Click OK
Only the checked items are displayed. Hidden rows are not deleted—they are temporarily hidden.
Example: To show only Bug-type Pokémon:
- Click the Type 1 column arrow
- Uncheck all types except "Bug"
- Click OK

Charts are visual representations of data that make patterns and comparisons easy to see. Common chart types include:
- Pie Chart: Shows parts of a whole as percentages
- Column Chart: Compares values across categories
- Line Chart: Shows trends over time
Creating a Chart
- Select the data range you want to visualise (include headers)
- Go to Insert tab
- Click the chart type you want (Pie, Column, or Line)
- Choose the specific chart style
- The chart appears on your worksheet
Worked Example: Creating a Column Chart
Suppose you have Pokémon statistics:
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Name | HP | Attack | Defense | Sp.Atk | Sp.Def | Speed |
| 2 | Charmander | 39 | 52 | 43 | 60 | 50 | 65 |
| 3 | Squirtle | 44 | 49 | 65 | 65 | 64 | 43 |
| 4 | Bulbasaur | 49 | 49 | 49 | 65 | 65 | 45 |
To create a column chart:
- Select the range A1:G4 (including headers)
- Click Insert → Column
- Choose Clustered Column
- A chart appears showing all three Pokémon compared across their stats
The chart makes it easy to see that Charmander has the highest Speed, while Squirtle has the highest Defense.
Customising Charts
- Click on the chart to select it
- Use the Chart Design and Format tabs to change colours, styles, and layouts
- Click on chart elements (title, legend, axis labels) to edit them directly
- Tables organise data and enable sorting, filtering, and easy data management
- Sorting arranges data in ascending or descending order
- Filtering hides unwanted data temporarily to focus on specific information
- Charts visualise data to reveal patterns, trends, and comparisons
- Always select all related columns before sorting to maintain data relationships
In Tanzania, small shop owners can use tables and charts to track daily sales. For example, a dukala owner in Dar es Salaam can enter daily sales amounts in a spreadsheet, create a table to calculate totals using formulas, and then make a pie chart to see which product category (like rice, sugar, or cooking oil) brings the most income each week. This helps them make better decisions about which items to stock more.
Jinsi utakavyotathminiwaTathmini ya mchakato · Tathmini ya matokeo · Tathmini ya maarifa
Tathmini ya mchakato
The student should be able to:
- Select suitable chart types for different data scenarios.
- Create and format tables for clear and logical data presentation
- Customize charts and tables using formatting tools (e.g., colors, styles, labels).
Tathmini ya matokeo
Charts and tables that accurately represent the data visually to convey clear insights.
Tathmini ya maarifa
Methods used: The trainee should explain how to:
- Select and create appropriate chart types based on data characteristics.
- Format and customize charts and tables for effective communication.
- Utilize tools like pivot tables for summarizing and analyzing large datasets.
Principles: The student should explain the principle of:
- Data visualization design, including clarity, simplicity, and accuracy.
- Choosing the right chart types for specific data comparisons (e.g., trends, proportions, distributions).
- Aligning visualizations with the audience's needs and comprehension level.
Theories: The trainee should explain: The trainee should explain:
- Visual perception and how they influence data interpretation.
- The role of visual hierarchies in guiding the viewer’s attention.
Detailed knowledge about:
- Common mistakes in data visualization and how to avoid them.
- Best practices for using colors, fonts, and spacing in charts and tables.
Swali
What is data visualization?
Ingia ili kuwasilisha jibu lako na lihesabiwe katika umahiri wako.
Ingia ili kufanya mazoeziMwalimu
Umekwama? Niulize chochote kuhusu mada hii.
Ingia ili kumuuliza Mwalimu wa AI wa Sonza kuhusu swali hili.
Ingia ili kuulizaMajadiliano
Hakuna maswali bado