Page 77 - modular4.0
P. 77
Chapter Profile
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 the colours, textures, pictures, etc.
Scatter Chart
Scatter charts also known as XY scatter plot charts. They show the correlations between the two sets
of values. The x and y axis is used to represent the data plots on the chart.
Envision your favourite tech personality as a Gizmo Gadget. How would you paint
their portrait in Excel?
FORMATTING A CHART
Excel 2019 provides various tools to improve the appearance of a chart. When you select a chart on
a slide, a new contextual tab named Chart Tools will appear. The Chart Tools tab contains two tabs
named Design and Format.
Chart Tools tab
These tabs contain various commands to change the layout, style, type and shape of the chart. Let’s
learn about some of these in detail.
Charts in Excel 75

