Page 41 - CG_v2.1_flipBooks_class_6
P. 41
In this chapter, we will learn about different types of charts and the sorting of data in Excel.
Charts in Excel
A chart is an effective way to display data in a pictorial form. Chart makes it easier to draw
comparisons and analyse the growth, relationships, and trends among the values in a table.
Components of a Chart
Chart Title: Chart title describes the main aim and content of the chart.
X-axis: X-axis is the horizontal axis of the chart. It is also called the category axis.
Y-axis: Y-axis is the vertical axis of the chart. It is also called the value axis.
Plot Area: It is the rectangular area bounded by the two axis. It contains the actual chart and
includes the plotted data, data series, category, and value axes.
Gridlines Chart Title
Plot Area
Data Series
Y-axis
X-axis Data Labels
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.
Charts in Excel 39

