Page 19 - TP_Play_V2.1_class7
P. 19
Data Series: Data series is related to the set of values. It is represented by the bars or slices
that represent the data values.
Data Labels: Data labels 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 selected chart
type. It makes reading and understanding the values easier.
Legend: Legend is a key which shows the meanings of symbols and colours used in the chart.
Chart Area: The area that includes all objects and elements in a chart.
TYPES OF CHARTS IN EXCEL 2016
Excel 2016 provides a variety of different chart formats
such as Bar, Column, Pie, Line, Area, Waterfall, Scatter,
Surface, or 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 axis. It uses connecting dots to display trends over a period of time. Line charts are mostly
used to depict Stock price trends, temperature trends, educational performance etc.
Column Chart
It is the most commonly used chart in Excel. 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. Column chart is used in cases like Sales comparison, survey
results, population distribution, educational performance etc.
Column Chart
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. Examples of pie charts are survey results, expense breakdown, geographical distribution
etc.
Charts in Excel 17

