Page 41 - CG_v2.1_flipBooks_class_6
P. 41

In this chapter, we will learn about different types of charts and the sorting of data in Excel.

                 Charts in Excel

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

                 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 axes.

                         Gridlines                                                                Chart Title





                                                                                                  Plot Area



                                                                                                  Data Series
                           Y-axis

                           X-axis                                                                 Data Labels
                                                                                                  Legend

                   Data Series: A 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: 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

                 Excel provides a variety of different chart formats,
                 such as Bar, Column, Pie, Line, Area, Doughnut,
                 Scatter, Surface, and Radar.

                 Line  Chart:  It  is  used  to  show  trends  over  a
                 period of time. It 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
                 over a period of time.

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