Page 31 - iPro_trackGPT_V5_Class8
P. 31

Gridlines
                                                                                                Chart Title
                         Chart Area


                                                                                                Plot Area
                         Y-axis Title

                                                                                                Data Series
                             Y-axis
                                                                                                Data Labels
                             X-axis
                                                                                                X-axis Title
                                                                                                Legend

                    Data Series: A data series is a collection of related values.
                    Data Labels: Data labels show data values, category names, series names, legend keys, and
                    values from cells.
                    Gridlines: Gridlines can be horizontal or vertical, depending on the chart type. They help
                    make it easier to read and understand the values.
                    Legend: The legend is a key that explains the symbols and colors used in the chart.
                    Chart Area: This is the area that includes all the objects and elements in a chart.

                    X-axis Title:  The  X-axis title  describes  the  information  or  categories  represented  on  the
                    horizontal axis of the chart.
                    Y-axis Title: The Y-axis title describes the measurement or values represented on the vertical
                    axis of the chart.

                 Types of Charts in Excel

                 Excel gives you different types of charts to fulfill your requirement. Depending on your data,
                 you can choose the most suitable one. Some commonly                         LINE CHART
                 used chart types available in Excel include Column Chart,
                 Line Chart, Pie Chart, Bar Chart, Area Chart, Scatter Chart,
                 Surface Chart, and Radar Chart.
                 Line Chart: It is used to show trends over a period of time.
                 It connects data  points with lines, helping to visualise
                 trends and patterns. This makes it easier to understand
                 how values increase or decrease over time.

                            COLUMN CHART                  Column Chart: A column chart is a type of graph that
                                                          uses vertical bars to show and compare different amounts
                                                          of data. Each bar represents a category or time period,
                                                          and the height of the bar shows the value or amount for
                                                          that category.










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