Page 15 - TP-Play_V-2.0_Book-7
P. 15

CHARTS IN EXCEL
               02














                           Your Aim


                           to learn about:
                                    Creating a Chart                 Components of a Chart
                                      Types of Charts in Excel 2016          Formatting a Chart



            A chart is an effective way to display data in a pictorial form. It makes it easier to draw comparison
            and analyse the growth, relationship and trends among the values in a table.
                CREATING A CHART


            To create a chart, follow the given steps:
            Step 1   Select the range of cells, for example A1:C5, in

                    this case.
            Step 2   Click on Column chart from Charts group under
                    Insert tab.
                                                                                      Data for the chart
            Step 3   Select a 2-D Column Chart option from the drop-down list. A chart will be inserted in
                    the Excel sheet as shown:

























                       Different types of charts                     2-D Column chart




                                                                                         Charts in Excel     15
   10   11   12   13   14   15   16   17   18   19   20