Page 21 - TP_Prime_V2.2_Class7
P. 21

A chart will be inserted in the Excel sheet as shown.

















                                  Different types of                    2-D Column chart                                    ADVANCED FEATURES OF EXCEL
                                        charts

                  Changing Chart Type

                 You can change the type of an existing chart at any time. Perform the following steps to
                 change the chart type:

                 Step 1:  Select the chart.                                                                               19
                 Step 2:   Click on the Change Chart Type command from Type group under the Design tab.









                                                              Design Tab
                 Step 3:  Click on the Line option from the left panel of the Change Chart Type dialog box.
                 Step 4:  Click on the Line with Markers option from the right panel.

                 Step 5:  Select the desired style in which you want to display your chart.
                 Step 6:  Click on the OK button.











                                                                                   The moon highlights different
                                                                                 aspects at different times, much
                                                                                  like filtering focuses on specific
                                                                                           data subsets.








                                   Change Chart Type dialog box
   16   17   18   19   20   21   22   23   24   25   26