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
   28   29   30   31   32   33   34   35   36   37   38