Page 23 - Plus_V2.2_C7_Flipbook
P. 23

Step 4:   Click on Line with Markers option from the right panel
                         under Line group.                                                           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.
                 The chart will change to Line Chart as shown.













                                                                                              The modern statistical
                                                                                              chart was invented by
                                                                                               the Scottish political
                                             Line chart                                         economist William
                                                                                               Playfair at the end of
                                                                                                 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