Page 63 - ModularV1.1 _c7_flipbook
P. 63
Data Labels: Data labels include data values, category names, series names, 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: Legend is a key that 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 MS EXCEL
MS Excel provides a variety of chart formats such
as Bar, Column, Pie, Line, Area, Doughnut, 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.
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 emphasise on a significant element.
Bar Chart: The bar chart displays the data in the
form of long rectangular rods also called bars. These
bars can be placed horizontally on the chart area. It
illustrates the comparisons amongst the individual
items. In this chart, categories are represented on
the vertical axis and values are represented on the
horizontal axis.
Charts in Excel 61

