Page 19 - TP_Prime_V2.2_Class7
P. 19
Chart Area: The area that includes all objects and elements in a chart.
Grid lines Chart Title
Plot Area
Data Series
Y-axis ADVANCED FEATURES OF EXCEL
X-axis Data Labels
Legend
Components of a Chart
Types of Charts in Excel
Excel provides a variety of chart formats such as LINE CHART
Bar, Column, Pie, Line, Area, Doughnut, Scatter, 17
Surface, or Radar.
Most of the used charts in Excel are as follows:
Line Chart: It is used to show trends over a period of
time. It is similar to plotting a graph on a graph paper
with its values on X and Y axes. It uses connecting dots
to display trends over a period of time.
COLUMN CHART Column Chart: It is usually used to display the data
in the form of vertical bars. It is used to show the
changes in data over a period of time or comparison
among the different data items. The categories
are represented on the horizontal axis and the
values are represented on the vertical axis.
Pie Chart: It is a circular chart divided into sectors
where each sector shows the relative size of each value.
It always shows only one data series. It is useful when
you want to emphasis on a significant element.
If Excel was a magical library, how would you sort books and filter books you had
read?

