Page 21 - Plus_V2.2_C7_Flipbook
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