Page 257 - IT_Play_V1.0 Class9
P. 257
The Chart Wizard dialog box appears with four steps on the left side as:
1. Chart Type 2. Data Range 3. Data Series 4. Chart Elements
Step 4: Select the Chart Type that best represents your data, for example, Column, Bar, Line, Pie and so on.
Step 5: Click on the Next button.
4
5
The Chart Wizard shows the
options of the Data Range
step. Here, the user specify the 6
appropriate range of cells for the
chart.
Step 6: Select the range of cells to display
the chart.
Step 7: Click on the Next button. 7
The Chart Wizard shows the options of
the Data Series step. Here, the user can
change the source range of all data series separately, including their labels along with the range of
categories.
Step 8: Select the Data ranges from the list for Border Color, Fill Color, Name and Y-Values.
Step 9: Edit the data series from other cells.
Step 10: Click on the Next button.
9
8
10
Create and Insert Different Types of Charts in a Spreadsheet 255

