Page 50 - 2611_SmartGPT Pro V(5.0) C-5

Legend: It is a key that shows the meanings of the symbols and colours used in the chart.

Chart Area: It includes all the objects and elements of a chart.

TYPES OF CHARTS IN EXCEL

Excel provides a variety of different chart
formats, such as Bar, Column, Pie, Line,
Area, and Scatter.

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.

Pie Chart: It is a circular chart divided into sectors
where each sector shows the relative size of each

value. It always shows only one data series. It is useful
when you want to put emphasis on a significant
element.

Bar Chart: The bar chart displays the data in
the form of long rectangular rods, also called
bars. These bars can be placed horizontally
on the chart area. It illustrates the
comparisons among the individual items. In

this chart, categories are represented on the
vertical axis and values are represented on
the horizontal axis.

48 Computer Science (V5.0)-V