Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    Legend: It is a key that shows the meanings of the symbols and colours used in the chart.

                          Chart Area: It includes all the objects and elements of a chart.

                      TYPES OF CHARTS IN EXCEL

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

                      Line Chart: It is used to show trends 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: It is usually used to display
                                                                          the data in the form of vertical bars. It is

                                                                          used to show the changes in data over a
                                                                          period  of time  or for comparison  among
                                                                          the different data items. The categories are
                                                                          represented on the horizontal axis, and the

                                                                          values are represented on the vertical axis.

                      Pie Chart: It is a circular chart divided into sectors
                      where  each sector  shows the relative  size  of each

                      value. It always shows only one data series. It is useful
                      when  you  want to  put  emphasis  on a significant
                      element.

                                                                        Bar Chart: The bar chart displays the data in
                                                                        the form of long rectangular rods, also called
                                                                        bars. These bars can be placed horizontally
                                                                        on the chart area. It illustrates  the
                                                                        comparisons among the individual items. In

                                                                        this chart, categories are represented on the
                                                                        vertical axis and values are represented on
                                                                        the horizontal axis.

                       48   Computer Science (V5.0)-V

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