Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 49 - 2611_SmartGPT Pro V(5.0) C-5
P. 49

    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.

                              Gridlines                                                          Chart Title

                                                                                                 Plot Area

                                                                                                 Data Series
                                Y-axis
                                                                                                Data Labels
                                X-axis
                                                                                                 Legend

                                                                                     Charts, Formulas & Functions in Excel  47

| 44 45 46 47 48 49 50 51 52 53 54 |