Page 18 - TP_Prime_V2.2_Class7
P. 18
02
ADVANCED FEATURES
OF EXCEL
Prime (Ver. 2.2)-VII Learning Objectives
• Charts in Excel
• Sorting Data
• Filtering Data
• Conditional Formatting
16 Yesterday, I was surfing the Internet, I saw a graph to represent the annual
sales of an organisation. Can we create a graph in Excel?
Yes, we can create graph (chart) in Excel. Let's learn about charts in Excel.
Charts in Excel
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
Chart Title: The chart title describes the main aim and content of the chart.
X-axis: The X-axis is the horizontal axis of the chart. It is also called the category
axis.
Y-axis: The Y-axis is the vertical axis of the chart. It is also called the value axis.
Plot Area: The plot area is the rectangular area bounded by the two axes. It contains
the actual chart and includes the plotted data, data series, category, and value axis.
Data Series: The data series is related to the set of values. It is represented by the
bars or slices that represent the data values.
Data Labels: Data labels include data values, category names, series names, legend keys
and values from cells.
Gridlines: Gridlines can be either horizontal or vertical lines depending on the selected
chart type. It makes it easier to read and understand the values.
Legend: The Legend is a key that shows the meanings of symbols and colours used in the
chart.

