Page 31 - iPlus_Ver_2.0_class_8
P. 31

•  Data Series: It is the set of values which the user wants to plot in the chart. It is represented
                    by the bars or slices that represent the data values.

                 •  Data Labels: It refers to the label that provides additional information about data marker,
                    thus representing a single data item or value of a cell.

                 •  Gridlines: It refers to the horizontal and vertical lines in the plot area. The gridlines are inserted
                    in the chart to enhance its readability.
                 •  Legend: It helps to identify the plotted data series. Unique colour or pattern is helpful to

                    identify such series.
                 •  Chart Area: It refers to the total area surrounded by the chart.

                 Types of Charts in Excel

                 Excel provides a  variety  of different  chart
                 formats, such as Bar, Column, Pie, Line, Area,
                 Doughnut, Scatter, Surface, and Radar.

                 Line Chart: A  line chart  is used to  view
                 information  that  is shown  by  lines at  equal
                 intervals. It depicts the change in data over a
                 period of time. It is similar to plotting a graph
                 on graph paper with its values on the X and Y

                 axes. It uses connecting dots to display trends
                 over a period of time.


                                                                     Column Chart: A column chart represents the
                                                                     data  over  a  period  of time in columns. Each
                                                                     column rises from  X-axis and  indicates the
                                                                     value of a data. The measurement values are
                                                                     shown vertically as Y-axis. The categories are
                                                                     represented  on the  horizontal  axis, and  the
                                                                     values are represented on the vertical axis.




                 Pie  Chart:  A pie chart  represents the  data or
                 value of each item in proportion or percentage
                 to the consolidated or the sum value of all items.
                 Pie chart displays single type of data item and is

                 beneficial when the user wants to emphasize value
                 of a significant item. Pie charts help to compare how
                 each value relates proportionally to the whole.







                                                                                                                  29
                                                                              Spreadsheet—Functions and Charts
   26   27   28   29   30   31   32   33   34   35   36