Area chart

Learning the basics to a Area Chart and how it is different from a line chart.

1. AREA CHART IS113 Spreadsheet management Presentation by; Lisa- marie Tamange NORAH YAFALIBUBU Lincy Pulube

2. Session outcome: At the end of this lesson, students should be able to; Describe Area chart Discuss the subtypes of Area chart Discuss Area chart uses Create Area chart Interpret the data on an Area chart

3. What is an area chart? An Area chart is a line chart where the data of various series are separated line and are present in different colors, which is used to show the impact and changes in various data series overtime. Area chart will appear having the area below the lines filled with colors. Area C hart Line Chart

4. Sub-types of Area chart 2-D Area chart Stacked area chart 100% Stacked area chart 3-D

5. Area Chart uses/Users The following are the uses of Area Chart; Useful when we have different time series data and we have to illustrate the relation of each set to the whole data Represents cumulated totals using numbers or percentage (100% stacked area or stacked area chart in the case) overtime. Used when the trend needs to be shown with the magnitude rather than individual data values Following are some of the users of Area Chart; Education Business

6. Steps involved in creating area chart Select the required data 2. Click the Insert tab in the Ribbon 3 . In the Chart group, click “Insert Line or Area Chart icon”. 4 . In the 2-D Area category, click on Area

7. Interpreting the area chart

8. Summary Area Chart is a line chart where the data of various series are separated lines which appear having the area below the lines filled with colors. Subtypes of Area Chart; Basic Area Chart Stacked Area Chart 100% Area Chart Area Chart uses Useful when we have different time series data and we want to showcase each set to the whole data Used when the trend needs to be shown with the magnitude rather individual data values Represents cumulated totals using numbers or percentages

9. References What is an Area Chart? ( n.d ). Retrieved from https:// study.com/academy/lesson/what-is-an-area-chart-definition-examples.html Area Chart in Excel. ( n.d ). Retrieved from https ://www.wallstreetmojo.com/area-chart-in-excel/ How to create Area graph in Excel. ( n.d ). Retrieved from https :// www.exceltip.com/tips/information-on-area-chart-excel.html Sumit , B. ( n.d ). How to Create an Area Chart in Excel (explained with Examples). Retrieved from https://trumpexcel.com/area-chart/ Mike, y (2019). A Complete Guide to Area Chart. Retrieved from https://chartio.com/learn/charts/area-chart-complete-guide/