Page 38 - Plus V4 with Adobe class 6
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 exams.
Excel is one of the most useful programs and provide 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 a pictorial form. It makes it easier to draw comparison
and analyse the 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 axes. It contains the actual chart and includes
the plotted data, data series, category and value axis.
Grid lines
Chart Title
Plot Area
Data Series
Y-axis
X-axis Data Labels
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: It labels includes data values, category name, series name, legend keys and values
from cells.
Gridlines: These can be either horizontal or vertical lines depending on the selected 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

