Page 38 - Plus V4 with Adobe class 6
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 exams.







        Excel is one of the most useful programs and provide 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 a pictorial form. It makes it easier to draw comparison
        and analyse the 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 axes. It contains the actual chart and includes
           the plotted data, data series, category and value axis.

                   Grid lines
                                                                                         Chart Title



                                                                                         Plot Area




                                                                                         Data Series
                      Y-axis
                      X-axis                                                             Data Labels


                                                                                         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: It labels includes data values, category name, series name, legend keys and values
           from cells.
             Gridlines: These can be either horizontal or vertical lines depending on the selected 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