Page 75 - 2622_Delhi Police Public School_C-6

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.

Area Chart: It is used to display the quantitative
magnitude of the data graphically. These charts are
based on the features of the line chart. They basically
emphasise the area between the line and the axis
with the help of colours, textures, pictures, etc.

Scatter Chart: Scatter charts are also known as XY
scatter plot charts. They show the correlation between
the two sets of values. The chart represents the data
plots using the x and y axes.

Creating a Chart

To create a chart, follow the given steps:

1 Select the
range of cells. Click on the Insert Column
2 Click on the 3
Insert tab. or Bar Chart button.

4 Select the 2-D Column
Chart option.

Charts, Formulas & Functions in Excel 73