Page 75 - modular4.0
P. 75

Chapter Profile
                        COMPONENTS OF A CHART


                 Following are the components of a chart:
                    Chart Title: Chart title describes the main aim and content of the chart.

                    X-axis: X-axis is the horizontal axis of the chart. It is also called the category axis.
                    Y-axis: Y-axis 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 axis. It contains the actual chart and
                    includes the plotted data, data series, category and value axis.


                        Gridlines                                                                    Chart Title







                                                                                                    Plot Area

                                                                                                    Data Series
                           Y-axis

                          X-axis                                                                    Data Labels


                                                                                                    Legend

                                                         Components of a Chart
                    Data Series: Data series is related to the set of values. It is represented by the bars or slices that
                    represent the data values.
                    Data Labels: Data labels includes 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.

                    Legend: Legend is a key which shows the meanings of symbols and colours used in the chart.
                    Chart Area: The area that includes all objects and elements in a chart.


                        TYPES OF CHARTS IN EXCEL 2019

                 Excel 2019 provides a variety of different chart formats such as Bar, Column, Pie, Line, Area, Waterfall,

                 Scatter, Surface, or Radar.

                 Line Chart
                 It is used to show trends over a period of time. It is

                 similar to plotting a graph on a graph paper with its
                 values  on  X  and  Y  axis. It  uses  connecting  dots  to
                 display trends over a period of time.





                                                                                                      Charts in Excel  73
   70   71   72   73   74   75   76   77   78   79   80