Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 22 - 2607_Trackpad_Pro_5.1_flipbook_C6
P. 22

    DOUGHNUT CHART
                                                                                            Doughnut Chart
                      A  doughnut chart consists of more than one                                                                                         CHANGING CHART TYPE

                      data series.  Each ring represents one data                                                                               You can change the type of an existing chart at any time. Perform the following steps to change the
                      series in this chart. It displays the relationship of                                                                     chart type:
                      parts to a whole.
                                                                                                                                                                                  1  Select the chart and click on Chart Design tab.

                                                Which chart is used to display the data in the form of long rectangular                                                                       2  Click on the Change Chart Type command.
                              uiz    Bee        rods?

                                                _______________________________________________________________                                           3  Click on desired option (here we choose Line option).

                                                                                                                                                                                                                  Line chart

                               CREATING A CHART

                      The first step in creating a chart is collecting the data which will be displayed in the chart. To create
                      a chart, follow the given steps:

                                  2  Click on the Insert tab.                                                                                                     4  Click on Line with

                                                                                                                                                                 Markers option.

                                                                                                                                                                  5  Click on the OK button.
                                                                                       3  Choose the
                                                                                      desired chart from                                        The chart will change to Line Chart as shown above.
                                                                                      the Charts group.
                        1  Select the data
                       range.                                                                                                                              SETTING THE DATA RANGE

                                                                                                                                                The chart is created on the basis of data in the cell ranges and when the data is updated within the
                      The chart will appear on the worksheet.                                                                                   range, it gets reflected in the chart immediately. However, when new rows and columns are added,
                                                                                                                                                they are not reflected in the charts. It can be done by following the given steps:
                                                                    CHART TITLE

                                                   100
                                                                                                                                                                                  1  Select the chart and click   2  Click on the Select Data
                                                    80
                                                    60                                                                                                                            on the Chart Design tab.       command in the Data group.
                                                    40
                                                    20
                                                     0
                                                          Hindi   English  Mathematics  Computer Sc.
                                                           1        2        3        4
                                                                    Ravi  Lakshay

                       20   Premium Edition-VI                                                                                                                                                                                Charts in Excel 2021  21

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