Page 69 - TP_Modular_V2.1_Class7
P. 69

CHARTS IN EXCEL
                    07














                                Your Aim

                                to learn about:

                                         Components of a Chart            Types of Charts in Excel 2016
                                           Creating a Chart                  Formatting a Chart


                 A chart is an effective way to display data in a pictorial form. It is used to draw comparison and
                 analyse the growth, relationship and trends among the values in a table. In this chapter, you will

                 learn about different types of charts and their components. You will also learn the process of
                 creating a chart.
                    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 axes. It contains the actual chart and

                    includes the plotted data, data series, category and value axis.


                       Grid lines                                                                    Chart Title







                                                                                                    Plot Area

                                                                                                    Data Series
                          Y-axis
                          X-axis                                                                    Data Labels


                                                                                                    Legend

                                                         Components of a Chart


                                                                                              Charts in Excel     67
   64   65   66   67   68   69   70   71   72   73   74