Page 323 - TP_IT_V1.0_C9_flipbpookl
P. 323

Step 3:   In the Chart Type step, select the Chart Type as Column from the Choose a Chart Type list box. It will insert a
                         column chart when you click on the Finish button.
                           You may format your chart before inserting it by following the next three steps - Data Range, Data Series, and
                         Chart Elements from the Steps section.
                 Step 4:  To format a chart, Click on the Next button in Chart Wizard. It shows the following options:
                           •  Data Range: You can edit the selected range by changing the cell address in this text box.
                           •  Data Series: It means the collection of data values which can be row-wise or column-wise represented
                             in a chart. You can choose anyone from here.
                           •  Row or Column Label: The text that appears for row and column values represented in charts can be
                             selected from here.
                 Step 5:  Choose the desired option.
                 Step 6:  Click on the Next button.


















                         The following options appear in the Chart Wizard:
                         •  Data series: Data series that can be added or modified.
                         •  Data ranges: Data ranges for the series that can be added or modified.
                 Step 7:  Choose the desired options.
                 Step 8:  Click on the Next button.


















                         The Chart Elements step appears with the following options:
                           •  Chart Title: It is used to specify the title to the chart.
                           •  Chart Subtitle: It is used to specify the subtitle of the chart.
                           •  X axis: It is used to specify the label to the horizontal axis.
                           •  Y axis: It is used to specify the label to the vertical axis.
                           •  Display Grids: It displays grid for  the X axis and Y axis.
                           •  Display legend: It displays the legends (Colour code of data value) on the Left, Right, Top or Bottom of
                             the chart.
                 Step 9:  Type the Title as Rainfall, X-axis as City, and Y-axis as Rainfall in MM.



                                                                                               Electronic Spreadsheet  321
   318   319   320   321   322   323   324   325   326   327   328