Page 23 - TP_Pluse_V2.2_Class_7
P. 23

Step 4:   Click  on the  Line with  Markers option  from  the  right
                         panel.                                                                      Factopedia














                                                                                                 A bubble chart is
                                                                                                 a variation of a
                                                                                              scatter chart in which
                                                                                               bubbles are used to
                                    Change Chart Type dialog box
                                                                                              represent data points.
                 Step 5:   Select the desired Line with Markers chart style.
                 Step 6:  Click on OK button.

                 The chart will change to Line Chart as shown.








                                                                                              The modern statistical
                                                                                              chart was invented by
                                                                                               the Scottish political
                                                                                                economist William
                                                                                               Playfair at the end of
                                             Line Chart                                          the 18th Century.




                          Let’s BaCk-uP


                   •  A chart is an effective way to display data in a pictorial form.
                   •  Line chart is used to show trends over a period of time.
                   •   Column chart is usually used to display the data in the form of
                     vertical bars.
                   •   Pie is a circular chart divided into sectors where each sector
                     shows the relative size of each value.
                   •  Bar chart displays the data in the form of long rectangular rods.
                   •   Area chart is used to display the quantitative magnitude of             There are 44 types of
                     the data graphically.                                                     charts and graphs in
                   •   Scatter chart shows the correlations between the two sets of                   Excel.
                     values.



                                                                                              Charts in Excel 2016  21
   18   19   20   21   22   23   24   25   26   27   28