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

