Page 38 - TP_Plus_v4_Class6
P. 38

Take Off                                                           Century   #Critical Thinking
                                                                                                  21 st
                                                                                                 Skills
                    If you get 95, 85, and 90 marks in Maths, English and Computer Science respectively then find out your
                    average marks and percentage of your marks.







              Excel is one of the most useful programs and provides us a wide range of tools to work with data. In this
              chapter, you will learn how to use charts, formulas and functions.


                   USING CHARTS


              A chart is an effective way to display data in pictorial form to make it more understandable. It makes
              it easier to draw comparisons and analyse the data for growth, relationship and trends among the
              values in a table. Excel provides a variety of different chart formats such as Bar, Column, Pie, Line, Area,
              Doughnut, Scatter, Surface and Radar.
              Components of a Chart

                   Chart Title: It describes the main aim and content of the chart.

                   X-axis: It is the horizontal axis of the chart. It is also called the category axis.
                   Y-axis: It is the vertical axis of the chart. It is also called the value axis.
                   Plot Area: It is the rectangular area bounded by the two axis. It contains the actual chart, data series,
                 category axis and value axis.

                          Gridlines
                                                                                               Chart Title



                                                                                               Plot Area




                                                                                               Data Series
                            Y-axis

                            X-axis                                                             Data Labels

                        Chart Area                                                             Legend


                   Data Series: It is related to the set of values. It is represented by the bars or slices that represent the
                 data values.
                   Data Labels: These include data values, category name, series name, legend keys and values from
                 cells.
                   Gridlines: These can be either horizontal or vertical lines depending on the chart type. It makes it
                 easier to read and understand the values.
                   Legend: It is a key which shows the meanings of symbols and colours used in the chart.

                   Chart Area: It includes all the objects and elements of a chart.


                  36  Plus (Ver. 4.0)-VI
   33   34   35   36   37   38   39   40   41   42   43