Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 42 - 2620_Birla Open Mind C-6
P. 42

    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.

                      40  Premium Edition-VI

| 37 38 39 40 41 42 43 44 45 46 47 |