Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 40 - 2632_CodeMind
P. 40

    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,
                     and Scatter.

                     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.

                                                                                                  More on Excel   39

| 35 36 37 38 39 40 41 42 43 44 45 |