Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 23 - 2626_South Point_C-7
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 |