Given Hapunda

148 Note that the nature of the data should guide you into the kind of chart you can use. For continuous data (interval and Ratio scale) use Histograms while categorical and ordinal data use pie or bar charts . Producing a simple bar chart requires the same steps but selecting bar chart option if the data is categorical or ordinal. However, bar charts for group data follow different commands. 1. Thus go to Analyse, 2. Descriptives 3. Cross tabs 4. Then enter the interest variables into the row and columns. It does not necessarily matter what variable is entered into the rows or columns. An example of a bar chart generated, is for households from each district that participated in a survey which could look like the one below. This graphical presentation shows the survey locations and the counts for households from each district. This gives immediate impressions on which location had more households. Figure 2: Bar Graph of Number Households in each District The line graph below is an example of how line graphs look like in Excel. To produce this line graph in excel is by ensuring that your data is set. Having data that is at least on a three-points of measurement, thus an intervention that was conducted on sample and the measures were done at three different points within the project period in order to assess the level of performance of the intervention for the entire time. 38 40 42 44 46 48 50 Mumbwa Chongwe Kafue Project Area