Page 39 - Trackpad_V4.0_c6_Flpbook
P. 39
Gridlines
Chart Title
Plot Area
Data Series
Y-axis
X-axis Data Labels
Legend
Legend: It is a key that shows the meanings of the 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, and Scatter.
Line Chart: It is used to show trends over a period of
time. It is similar to plotting a graph on graph paper
with its values on the X and Y axes. It uses connecting
dots to display trends over a period of time.
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 for
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 put emphasis
on a significant element.
Charts, Formulas & Functions in Excel 37

