Creating Graphs and Charts

From the previous tutorial we have learned how to LOOK UP a value. We have successfully converted the student's raw scores to its equivalent rating... Now, we will learn how to create a Chart and a Graph base from the student's final grades.

Before we proceed, let us first summarize the ratings by creating a frequency distribution table.

1. Make a list of all it categories on any cell of the same worksheet and make the use of the countif formula with format =countif(range;crieteria)

2. To get the frequency of COUNT, type countif(highlight the data under GRADES for the range--- put a colon (;)--- highlight the cell with 5 category--- type ) ---press enter

3. Same step will follow to get the frequency of the following grades.

From the frequency distribution table we have made,

1. To get the percentile of the count, type =highlight the cell that contains the frequency of count ---type / (indicate division sign) ---click the total number of students (ex. 50) ---press enter. You can multiply it by 100 or simply click the percentile icon (%) on the toolbar.

2. The same procedure would follow to get the percentile of the following grades.

CREATING A CHART

In general, to create a chart:

1. Select the cells that contain the data you want to use in the chart.

2. Click the INSERT tab on the toolbar.

3. Click the type of chart you want to create.

MODIFY A CHART

Once you have created a chart you can do several things to modify the chart.

Chart Wizard
The Chart Wizard appear as a dialog box when you click on the chart. The steps are located at the left side: Chart Type, Data Range, Data Series, Chart Elements

Within the Data Range and Data Series you can control the labels, and analysis.

Within the Chart Elements you can put a title or if you want a subtitle on your chart and axes.

PIE CHART
-provides another graphical device for presenting relative frequency and percent frequency distributions for categorical data.

To make a pie chart,

1. Highlight the categories of variable grade and count from the frequency distribution table we have made.

2. Click on the INSERT tab ---click on Chart ---click on Pie chart. Chart appears.

The output should be

Note: To edit the chart, right click on the chart and task bar of OpenOffice will appear like this.

Format Data Series: changing the color, direction and styles of the chart.

Format Data Labels: changing fonts, formats etc.

Chart Type: changing the appearance of the chart

3. You can put title or subtitle from the chart elements on the chart wizard, as discussed above.

LINE GRAPH

To create a Line Graph, we just have to follow the steps we made in creating a Pie Graph.

1. Highlight the categories of variable grade and count from the frequency distribution table we have made.

2.  Click on the INSERT tab ---click on Chart ---click on Line Graph.

3. Click on NEXT to modify the graph. The output should be:

Note: To edit the graph, right click on the graph and task bar of OpenOffice will appear.