Page 31 - TP_iPlus_V2.1_Class8
P. 31

Components of a Chart

                 •  Chart Title: It is the heading text that helps to identify the chart. The chart title describes the
                    aim and content of the chart.
                 •  X-Axis: The x-axis is the horizontal axis of the chart, commonly known as the category axis.

                 •  Y-Axis: The y-axis is the vertical axis of the chart, commonly known as the value axis.
                 •  Plot Area: It is that area of the chart in which the data is plotted.
                    In a 2-D chart; axis bound the plot area whereas in 3-D charts, walls and floors bound the plot
                    area.
                                                                                                 Chart Area
                         Gridlines                                                               Chart Title





                                                                                                 Plot Area



                                                                                                 Data Series
                           Y-axis
                           X-axis                                                                Data Labels
                                                                                                 Legend

                 •  Data Series: It is the set of values which the user wants to plot in the chart. It is represented

                    by the bars or slices that represent the data values.
                 •  Data Labels: It refers to the label that provides additional information about data marker,
                    thus representing a single data item or value of a cell.
                 •  Gridlines: It refers to the horizontal and vertical lines in the plot area. The gridlines are inserted

                    in the chart to enhance its readability.
                 •  Legend: It helps to identify the plotted data series. Unique colour or pattern is helpful to
                    identify such series.
                 •  Chart Area: It refers to the total area surrounded by the 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: A  line chart  is used to  view
                 information  that  is shown  by  lines at  equal
                 intervals. It depicts the change in data 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.


                                                                                                                  29
                                                                              Spreadsheet—Functions and Charts
   26   27   28   29   30   31   32   33   34   35   36