Page 31 - iprime_V2.2_class8
P. 31

Tech Funda




                            Common functions like SUM, AVERAGE, MAX, and MIN can
                            also be accessed from the drop-down arrow of the AutoSum
                            command.
                            To use other functions, click More Functions.









                     CHARTS IN EXCEL

                 A chart is an effective way to display data in a pictorial form. It makes it easier to draw comparisons
                 and analyse growth, relationships, and trends among values in a table.

                 Components of a Chart

                    Chart Title: The chart title describes the aim and content of the chart.

                    X-axis: X-axis, also known as category axis, is the horizontal axis of the chart.
                    Y-axis: Y-axis, also known as value axis, is the vertical axis of the chart.
                    Plot Area: Plot area is  the rectangular area bounded by the two axis that contains the actual

                    chart and includes plotted data.
                            Gridlines
                                                            SALES OF BICYCLES                    Chart Title
                                            3500
                                                                                                 Chart Area
                                           Price per Bicycle 3000                                Plot Area
                                            2500
                                            2000
                                            1500
                                            1000
                                                                                                 Data Series
                                             500
                              Y-axis
                                              0
                              X-axis               Classic     Gear      Hiking   Advanced       Data Labels
                                                                   Models

                                                         Bicycle Sold  Price Per Bicycle         Legend
                                                         Components of a Chart

                    Data Series: A data series refers to a set of related values, represented by bars, slices, or other
                    markers in a chart.
                    Data Labels:  Data  labels display information  such  as data  values,  category  names,  series
                    names, legend keys, and values from cells.

                    Gridlines: Gridlines are either horizontal or vertical lines that help in reading and interpreting
                    the chart’s data more easily.




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