Page 18 - TP_Prime_V2.2_Class7
P. 18

02

                                                   ADVANCED FEATURES

                                                                 OF EXCEL


           Prime (Ver. 2.2)-VII                                              Learning Objectives






                                                                             •  Charts in Excel
                                                                             •  Sorting Data
                                                                             •  Filtering Data
                                                                              •  Conditional Formatting




          16                      Yesterday, I was surfing the Internet, I saw a graph to represent the annual
                                 sales of an organisation. Can we create a graph in Excel?

                                  Yes, we can create graph (chart) in Excel. Let's learn about charts in Excel.




                    Charts in Excel


                  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

                     Chart Title: The chart title describes the main aim and content of the chart.
                      X-axis: The X-axis is the horizontal axis of the chart. It is also called the category
                    axis.

                     Y-axis: The Y-axis is the vertical axis of the chart. It is also called the value axis.
                      Plot Area: The plot area 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.

                      Data Series: The 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 include data values, category names, series names, legend keys
                    and values from cells.

                      Gridlines: Gridlines can be either horizontal or vertical lines depending on the selected
                    chart type. It makes it easier to read and understand the values.

                      Legend: The Legend is a key that shows the meanings of symbols and colours used in the
                    chart.
   13   14   15   16   17   18   19   20   21   22   23