Page 38 - TP_Plus_v4_Class6
P. 38
Take Off Century #Critical Thinking
21 st
Skills
If you get 95, 85, and 90 marks in Maths, English and Computer Science respectively then find out your
average marks and percentage of your marks.
Excel is one of the most useful programs and provides us a wide range of tools to work with data. In this
chapter, you will learn how to use charts, formulas and functions.
USING CHARTS
A chart is an effective way to display data in pictorial form to make it more understandable. It makes
it easier to draw comparisons and analyse the data for growth, relationship and trends among the
values in a table. Excel provides a variety of different chart formats such as Bar, Column, Pie, Line, Area,
Doughnut, Scatter, Surface and Radar.
Components of a Chart
Chart Title: It describes the main aim and content of the chart.
X-axis: It is the horizontal axis of the chart. It is also called the category axis.
Y-axis: It is the vertical axis of the chart. It is also called the value axis.
Plot Area: It is the rectangular area bounded by the two axis. It contains the actual chart, data series,
category axis and value axis.
Gridlines
Chart Title
Plot Area
Data Series
Y-axis
X-axis Data Labels
Chart Area Legend
Data Series: It is related to the set of values. It is represented by the bars or slices that represent the
data values.
Data Labels: These include data values, category name, series name, legend keys and values from
cells.
Gridlines: These can be either horizontal or vertical lines depending on the chart type. It makes it
easier to read and understand the values.
Legend: It is a key which shows the meanings of symbols and colours used in the chart.
Chart Area: It includes all the objects and elements of a chart.
36 Plus (Ver. 4.0)-VI

