Page 20 - Plus_V2.2_C7_Flipbook
P. 20
Grid lines
Chart Title
Plot Area
Data Series
Y-axis
X-axis Data Labels
Legend
Components of a Chart
• 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 shows information about a data series or its individual data points.
• 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.
TYPES OF CHARTS IN EXCEL
Excel provides a variety of different chart formats such
as Bar, Column, Pie, Line, Area, Doughnut, Scatter,
Surface and Radar.
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 of a data over a given period of time.
Column Chart: It is commonly 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 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
18 Premium Edition-VII

