Outline four types of charts that could be created using spreadsheet programs. (4 marks)July 2020

There are many types of charts that can be created using spreadsheet programs, including:

1. Line charts: Line charts are used to display trends over time or to compare multiple sets of data. They consist of data points connected by lines, and are often used to display data that changes continuously over time.
2. Column charts: Column charts are used to compare different categories of data. They consist of vertical columns, and are often used to display data that has discrete values (such as the number of products sold in different months).
3. Bar charts: Bar charts are similar to column charts, but the bars are horizontal instead of vertical. They are often used to display data that has discrete values, and can be used to compare multiple sets of data.
4. Pie charts: Pie charts are used to display data as proportions of a whole. They consist of a circle divided into wedges, with each wedge representing a different category of data.
5. Scatter plots: Scatter plots are used to display the relationship between two sets of data. They consist of data points plotted on a graph, and are often used to identify patterns or trends in the data.
6. Bubble charts: Bubble charts are similar to scatter plots, but they include a third data set represented by the size of the data points (bubbles). They are often used to display data with three variables.