Page 62 - ModularV1.1 _c6_flipbook
P. 62

07                       CHARTS IN EXCEL



















                                 Your Aim

                                 to learn about:
                                        Components of a Chart            Types of Charts in MS Excel
                                          Creating a Chart                  Formatting a Chart



                  A chart is an effective way to display data in a pictorial form. It makes it easier to draw comparison
                  and analyse the growth, relationship and trends among the values in a table.

                      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 bound by the two axis. 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

                      Data Series: Data series is related to the set of values. It is represented by the bars or slices
                     that represent the data values.

                  60      Modular (Ver. 1.1)-VII
   57   58   59   60   61   62   63   64   65   66   67