Page 226 - CA_165_V2.0_C9_Flipbook
P. 226

Data series          It is the set of values which the user wants to plot in the chart.
                    Chart Area           It refers to the total area surrounded by the chart.

                                         It is that area of the chart in which the data is plotted.
                    Plot Area            In a 2-D chart; axis bound the plot area whereas in 3-D charts, walls and floors
                                         bound the plot area.
                    Chart Title          It is the heading text that helps to identify the chart.

                    Axis Title           It refers to the titles given to three axis, i.e. X, Y and Z axis.
                                         It helps to identify the plotted data series. Unique colour or pattern is helpful
                    Legend
                                         to identify such series.
                                         It refers to the horizontal and vertical lines in the plot area. The gridlines are
                    Gridlines
                                         inserted in the chart to enhance its readability.
                                         It refers to the label that provides additional information about data marker,
                    Data Label
                                         thus representing a single data item or value of a cell.
                                         In a 3-D chart, the base area or the plane in X-Y axis is called the floor and the
                    Walls and Floors
                                         vertical areas, i.e. planes in X-Z and Y-Z axis are called walls.

                  Advantages of Charts

                  Following are the advantages of charts:
                  l    Charts summarise large data set in visual form and estimate key value at a glance.

                  l    Charts are visually appealing and it is easy for the users to compare the information.

                  l    Charts help to forecast the trends on the basis of comparisons done.
                  Types of Charts

                  There are different types of charts. Some of them are:

                                                                                         LINE CHART
                                                                       120
                                                                       110
                  l    Line Chart: Line chart is used to view          100
                                                                        90
                       information that is shown by lines at equal      80
                       intervals. It depicts the change in data         70
                                                                        60
                       over a period of time.                           50
                                                                        40
                                                                        30
                                                                        20
                                   COLUMN CHART                         10
                  120                                                    0     English       Maths        Science
                  110                                                                  Kavya    Pooja   Ankit
                  100
                   90
                   80
                   70
                   60                                                   l  Column  Chart: A column chart represents
                   50
                   40                                                      data over a period of time in columns. Each
                   30
                   20                                                      column rises from X-axis and indicates the
                   10
                    0                                                      value of a data. The measurement values are
                          English       Maths        Science               shown vertically on the Y-axis.
                                    Kavya Pooja Ankit


                   224   Touchpad Computer Applications (Ver. 2.0)-IX
   221   222   223   224   225   226   227   228   229   230   231