Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 15 - 2617_JSSPS_C-6
P. 15

    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  among  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 colours, textures, pictures, etc.

                                                                      Scatter Chart: Scatter charts are also known  as XY
                                                                      scatter plot charts. They show the correlation between
                                                                      the two sets of values. The chart represents the data
                                                                      plots using the x and y axes.

                     Creating a Chart

                     To create a chart, follow the given steps:

                        1   Select the
                            range of cells.                                                 Click on the Insert Column
                                                                      2   Click on the   3
                                                                          Insert tab.       or Bar Chart button.

                                    4   Select the 2-D Column
                                        Chart option.

                                                                                 Charts, Formulas & Functions in Excel  13

| 10 11 12 13 14 15 16 17 18 19 20 |