taohaa.blogg.se

Once the chart function is initiated, a 'Chart Wizard' pops out which shows a set of chart types that can be created. If the chart button is not visible, click on the 'Insert' option and click on the 'Chart.' option in the drop-down menu that will appear (see Figure 2a).įigure 2 and Figure 2a: Initiating the chart function Next, click on the chart button on the menu ribbon as shown in Figure 2. Here, we create a table with two columns, the first for the month and the second for the number of admissions corresponding to that month (see Figure 1).įigure 1: Creating a table of monthly admissions data

For this exercise, we will use OpenOffice Calc as our spreadsheet software.

Table 1: Admissions-over-time data for a CMAM program in Somaliaįirst thing to do is to enter the data in a spreadsheet. Creating line graphs are useful in visualising trend of a data series over time such as that for showing trend of admissions-over-time or defaulters-over-time.įor this exercise, we will use the data on admissions-over-time data as an example (see Table 1).