Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 13 - 2617_JSSPS_C-6
P. 13

    Release the mouse button on the cell up to which you want to select the range.

                     Naming a Cell Range

                     Excel allows us to assign a name to a cell range. This name can be used in place of the cell address in
                     formulas. Perform the following steps to assign a name to a cell range:

                                                                                              Click on the  Define   3

                          2   Click on the                                                    Name button.
                              Formulas tab.

                                                                                              Select the range of
                                                                                              cells to which you      1
                                                                                              want to assign a name.

                       4
                           Type the name.

                          5   Click on the
                              OK button.

                     Now, we can use this name in place of the cell address in formulas.

                     USING CHARTS

                     A chart is an effective way to display data in pictorial form. It makes it easier to draw comparisons and
                     analyse the growth, relationships 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.

                        Data Series: It is related to the set of values. The bars or slices 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 selected chart type. It
                       makes it easier to read and understand the values.

                                                                                 Charts, Formulas & Functions in Excel  11

| 8 9 10 11 12 13 14 15 16 17 18 |