Page 33 - iprime_V2.2_class8
P. 33
Scatter Chart: It is also known as XY scatter plot
chart. It shows the correlation between two sets of
values. The x and y axes are used to represent the
data plots on the chart.
Creating a Chart
To create a chart, follow these steps:
Step 1 Select the range of cells, for example,
A1:C5, in this case.
Step 2 Click on the Column chart from the
Charts group under the Insert tab. Data for the Chart
Charts Group
Step 3 Select the Clustered Column chart in the 2-D Column section from the drop-down list.
A chart will be inserted into the Excel sheet as shown.
Different Types of Charts 2-D Column Chart
Change Chart Type
You can change the type of an existing chart at any time. To change the chart type, follow these
steps:
Step 1 Select the chart.
Step 2 Click on the Change Chart Type command from the Type group under the Design tab
under Chart Tools.
Spreadsheet—Functions and Charts 31

