Page 41 - Computer Genius Class 06
P. 41

n this chapter   e  ill learn a out different types o  charts and the sorting o  data in   cel.

                 Charts in Excel

                    chart  is  an  effecti e   ay  to  display  data  in  a  pictorial   orm.   hart  ma es  it  easier  to  dra
                 comparisons and analyse the growth, relationships, and trends among the values in a table.

                 Components of a Chart

                   Chart Title:  hart title descri es the main aim and content o  the chart.
                   X-axis:   a is is the hori ontal a is o  the chart.  t is also called the category axis.

                   Y-axis:   a is is the  ertical a is o  the chart.  t 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 axes.

                         Gridlines                                                                Chart Title





                                                                                                  Plot Area



                                                                                                  Data Series
                           Y-axis

                           X-axis                                                                 Data Labels
                                                                                                  Legend

                   Data Series:   data series is related to the set o   alues.  t is represented  y the  ars or slices
                   that represent the data values.

                   Data Labels:  ata la els include data  alues  category names  series names  legend  eys  and
                    alues  rom cells.
                   Gridlines: These can be either horizontal or vertical lines depending on the selected chart type.
                    t ma es it easier to read and understand the  alues.
                   Legend:  egend is a  ey  hich sho s the meanings o  sym ols and colours used in the chart.

                   Chart Area: The area that includes all objects and elements in a chart.
                 Types of Charts in Excel

                   cel pro ides a  ariety o  different chart  ormats
                 such as Bar, Column, Pie, Line, Area, Doughnut,
                  catter   ur ace  and  adar.

                 Line  Chart:  It  is used to show  trends  over  a
                 period o  time.  t is similar to plotting a graph
                 on graph paper with its values on the X and Y
                 axes. It uses connecting dots to display trends
                 o er a period o  time.

                                                                                             Charts in Excel  39
   36   37   38   39   40   41   42   43   44   45   46