Page 72 - TP_Modular_V2.1_Class7
P. 72
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.
CREATING A CHART Scatter Chart
Now that you have learnt about different types of charts. Let us learn how to create charts. To
create a chart, follow the given steps:
Step 1 Select the range of cells, for example A1:C5, as
shown in the figure.
Step 2 Click on the Insert Column or Bar Chart from
Charts group under Insert tab.
Step 3 Select a 2-D Column Chart option from the Data for the chart
drop-down list. A chart will be inserted in the Excel sheet as shown:
Different types of charts 2-D Column chart
FORMATTING A CHART
Excel 2016 provides various tools to improve the appearance of a chart. When you select a chart
in excel, 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.
70 Modular (Ver. 2.1)-VII

