How to make frequency plots and histograms using excel

The measurements of dihedral angle, bond length and bond angle from the R code needs to be gathered into frequency plots to show how these measurements are distributed around the most common value(s).

​

Below is a tutorial on how to do this in excel.

Jakob Humphrey outlines the process of making a histogram in excel using the Leucine Bond Angle CO-N-CA data collected from Wincoot as an example.

​

Document Used