Page 21 - TP_Play_V2.1_class7
P. 21

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.





                                                                                              Charts in Excel     19
   16   17   18   19   20   21   22   23   24   25   26