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
   67   68   69   70   71   72   73   74   75   76   77