Page 229 - CA_165_V2.0_C9_Flipbook
P. 229

The pointer moves to Data Series. Here the user can change the source range of all data series
                          separately, including their labels along with the range of the categories.
                 Step 9:   Select the data range from the list for Name and Y-Values.

                 Step 10:  Edit data series from other cells.
                 Step 11:  Click on Next button.







                           10                                                                             9










                                                                                                         11


                 Step 12:  Mention the title and subtitle of the chart.

                 Step 13:  Click on the Y-axis checkbox in Display grids section.
                 Step 14:  Click on Display Legend checkbox and set the position.

                 Step 15:  Click on Finish button.





                               12
                                                                                                     14





                               13


                                                                                                     15

                          The chart will be displayed in the sheet, which can be Cut or Copied and Pasted at other locations.























                                                                                                Data Analysis    227
   224   225   226   227   228   229   230   231   232   233   234