Page 37 - Chinmaya_C6_flipbook
P. 37
Y-axis: It is the vertical axis of the chart. The value of each data series is plotted on this axis. It is
also known as the value axis.
Data Series: It is related to the set of values. It is represented by the bars or slices that have data
values.
Legend: It is a key that displays the symbols or colours used in the chart.
Chart Area: It includes all objects and elements of a chart.
Gridlines: These can be either horizontal or vertical lines depending on the selected chart type. It
makes it easier to read and understand the values.
Plot Area: It is a rectangular area that contains two axes. It carries the actual chart and includes
the plotted data, data series, category and value axis.
Tick ( ) if you know this.
Charts are used to represent data in a graphic form.
Y-axis is the horizontal axis in a chart.
TYPES OF CHARTS
Excel provides numerous types of charts to present data in diverse ways. Let us discuss a few
commonly used charts.
COLUMN CHART
A column chart is used to display data in the form
of vertical bars within a specified time period. These
vertical bars are used to show the comparison
between categories which are represented by
rectangles. The categories are typically organised
along the horizontal axis and values along the
vertical axis.
BAR CHART
A bar chart is used to display the data in the
form of long rectangular rods, also called bars.
The categories are represented on the vertical
axis and values are represented on the horizontal
axis. It is used to compare individual items and
also highlights a comparison of values. A bar
chart is also known as a histogram.
34 Premium Edition-VI Charts in Excel 2016 35

