now show you how to create a histogram given a frequency distribution and or relative frequency distribution you can create a histogram with spreadsheets doing the following go to select the frequencies and go to insert column select the clustered column this essentially is a frequency distribution but the horizontal axis is not labeled correctly you don't like something you can click on it and hit delete to remove it for most frequency distributions we wouldn't like any gaps between the bars right click on one of the bars and format data series to remove the gap we can then change the horizontal labels by right clicking and going to select data under horizontal access labels hit edit then choose the classes then hit okay and okay the bottom is now labeled we can title the axes the vertical axis will always be frequency or relative frequency the hor IAL axis will vary depending on the problem to create a relative frequency histogram repeat the same thing but use the relative frequencies use the same classes for both notice the two graphs have the same shape this is because the heights of the bars are proportional and all we've done is divide each of the heights by 40 with the rescaling of the vertical axis no difference is seen other than the scaling on the vertical axis since the same information can be determined from both there are alternate ways of looking at the same data set