Page 41 - Computer Genius Class 06
P. 41
n this chapter e ill learn a out different types o charts and the sorting o data in cel.
Charts in Excel
chart is an effecti e ay to display data in a pictorial orm. hart ma es it easier to dra
comparisons and analyse the growth, relationships, and trends among the values in a table.
Components of a Chart
Chart Title: hart title descri es the main aim and content o the chart.
X-axis: a is is the hori ontal a is o the chart. t is also called the category axis.
Y-axis: a is is the ertical a is o the chart. t 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: data series is related to the set o alues. t is represented y the ars or slices
that represent the data values.
Data Labels: ata la els include data alues category names series names legend eys and
alues rom cells.
Gridlines: These can be either horizontal or vertical lines depending on the selected chart type.
t ma es it easier to read and understand the alues.
Legend: egend is a ey hich sho s the meanings o sym ols and colours used in the chart.
Chart Area: The area that includes all objects and elements in a chart.
Types of Charts in Excel
cel pro ides a ariety o different chart ormats
such as Bar, Column, Pie, Line, Area, Doughnut,
catter ur ace and adar.
Line Chart: It is used to show trends over a
period o time. t 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
o er a period o time.
Charts in Excel 39

