Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 21 - 2626_South Point_C-7
P. 21

    where each  sector  shows the  relative  size  of each value. It
                     always shows only one data series. It is useful when you want
                     to emphasise  on a significant element.

                                                                      Bar Chart:  The bar chart displays the data in the
                                                                 form of long rectangular rods also called bars. These bars
                                                                 can be placed horizontally on the chart area. It illustrates
                                                                 the  comparisons  amongst  the  individual  items.  In this

                                                                 chart,  categories  are  represented  on  the  vertical  axis
                                                                 and values are represented on the horizontal axis.

                          Area Chart: It is used to display the quantitative
                     magnitude  of  the data  graphically. These charts are
                     based on the features of the line chart. They basically
                     emphasise the area between the line and the axis with

                     the help of the colours, textures, pictures, etc.

                                                                    Scatter Chart: Scatter charts are also known as XY
                                                               scatter plot charts. They show the correlations between the
                                                               two sets of values. The x and y axes are  used to represent
                                                               the data plots on the chart.

                             Let’s CatCh uP

                       Write the names of any four types of charts.
                       1. ____________________                           2. ____________________

                       3. ____________________                           4. ____________________

                            CREATING A CHART

                     Now that you have learnt about different types of charts. Let us
                     learn how to create charts.

                     To create a chart, follow these steps:

                                                                                                Data for the chart

                                                                                                  Charts in Excel 2016  19

| 16 17 18 19 20 21 22 23 24 25 26 |