Page 31 - iprime_V2.2_class8
P. 31
Tech Funda
Common functions like SUM, AVERAGE, MAX, and MIN can
also be accessed from the drop-down arrow of the AutoSum
command.
To use other functions, click More Functions.
CHARTS IN EXCEL
A chart is an effective way to display data in a pictorial form. It makes it easier to draw comparisons
and analyse growth, relationships, and trends among values in a table.
Components of a Chart
Chart Title: The chart title describes the aim and content of the chart.
X-axis: X-axis, also known as category axis, is the horizontal axis of the chart.
Y-axis: Y-axis, also known as value axis, is the vertical axis of the chart.
Plot Area: Plot area is the rectangular area bounded by the two axis that contains the actual
chart and includes plotted data.
Gridlines
SALES OF BICYCLES Chart Title
3500
Chart Area
Price per Bicycle 3000 Plot Area
2500
2000
1500
1000
Data Series
500
Y-axis
0
X-axis Classic Gear Hiking Advanced Data Labels
Models
Bicycle Sold Price Per Bicycle Legend
Components of a Chart
Data Series: A data series refers to a set of related values, represented by bars, slices, or other
markers in a chart.
Data Labels: Data labels display information such as data values, category names, series
names, legend keys, and values from cells.
Gridlines: Gridlines are either horizontal or vertical lines that help in reading and interpreting
the chart’s data more easily.
Spreadsheet—Functions and Charts 29

