Page 31 - iPlus_Ver_2.0_class_8
P. 31
• Data Series: It is the set of values which the user wants to plot in the chart. It is represented
by the bars or slices that represent the data values.
• Data Labels: It refers to the label that provides additional information about data marker,
thus representing a single data item or value of a cell.
• Gridlines: It refers to the horizontal and vertical lines in the plot area. The gridlines are inserted
in the chart to enhance its readability.
• Legend: It helps to identify the plotted data series. Unique colour or pattern is helpful to
identify such series.
• Chart Area: It refers to the total area surrounded by the 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: A line chart is used to view
information that is shown by lines at equal
intervals. It depicts the change in data 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: A column chart represents the
data over a period of time in columns. Each
column rises from X-axis and indicates the
value of a data. The measurement values are
shown vertically as Y-axis. The categories are
represented on the horizontal axis, and the
values are represented on the vertical axis.
Pie Chart: A pie chart represents the data or
value of each item in proportion or percentage
to the consolidated or the sum value of all items.
Pie chart displays single type of data item and is
beneficial when the user wants to emphasize value
of a significant item. Pie charts help to compare how
each value relates proportionally to the whole.
29
Spreadsheet—Functions and Charts

