Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 33 - logicode 2609 C6
P. 33

    Y-axis: It is the vertical axis of the chart. The value of each data series is plotted on this axis. It
                       is also known as the value axis.
                       Data Series: It is related to the set of values. It is represented by the bars or slices that have
                       data values.

                       Legend: It is a key that displays the symbols or colours used in the chart.
                       Chart Area: It includes all objects and elements of a chart.
                       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.

                       Plot Area: It is a rectangular area that contains the two axes. It carries the actual chart and
                       includes the plotted data, data series, category and value axis.

                          Tick ( ) if you know this.
                             Charts are used to represent data in a graphic form.

                              Y-axis is the vertical axis in a chart.

                               TYPES OF CHARTS

                     Excel provides numerous types of charts to present data in diverse ways. Let us discuss a few

                     commonly used charts.

                     COLUMN CHART

                     A  column chart is  used  to  display  data  in the
                     form of vertical  bars within  a specified  time
                     period.  These  vertical  bars  are used  to  show
                     the comparison  between  categories  which are
                     represented  by columns. The  categories  are

                     typically organised along the horizontal axis and
                     values along the vertical axis.

                                                                       BAR CHART

                                                                       A  bar chart is used to display the data in the
                                                                       form of long rectangular rods, also called bars.
                                                                       The categories are represented on the vertical
                                                                       axis and values are represented on the horizontal
                                                                       axis. It is used to compare individual items and
                                                                       also highlights a comparison of values.

                                                                                        Advanced Features of Excel 2021   31

| 28 29 30 31 32 33 34 35 36 37 38 |