Page 53 - 2502_Pakistan-kifayat_C-8

Gridlines Chart Title

Plot Area

Data Series
Y-axis

Data Labels
X-axis
Legend

Data Series: A 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 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 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

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 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.

#Microsoft Excel 51