Page 62 - ModularV1.1 _c6_flipbook
P. 62
07 CHARTS IN EXCEL
Your Aim
to learn about:
Components of a Chart Types of Charts in MS Excel
Creating a Chart Formatting a Chart
A chart is an effective way to display data in a pictorial form. It makes it easier to draw comparison
and analyse the growth, relationship and trends among the values in a table.
COMPONENTS OF A CHART
Following are the components of a chart:
Chart Title: Chart title describes the main aim and content of the chart.
X-axis: X-axis is the horizontal axis of the chart. It is also called the category axis.
Y-axis: Y-axis is the vertical axis of the chart. It is also called the value axis.
Plot Area: It is the rectangular area bound by the two axis. It contains the actual chart and
includes the plotted data, data series, category and value axis.
Grid lines
Chart Title
Plot Area
Data Series
Y-axis
X-axis Data Labels
Legend
Components of a Chart
Data Series: Data series is related to the set of values. It is represented by the bars or slices
that represent the data values.
60 Modular (Ver. 1.1)-VII

