How to Make Clustered Histograms on Excel

1. Open your Microsoft Excel worksheet that contains the data for your chart. Label a new column as Bin Range, and type the groups of values that you want to use as your horizontal axis. For example, if you're counting the frequency of test scores, type '
2. Label a new column 'Frequency1' to the right of your Bin Range column. Count the number of occurrences for each of your groups of your first data set and type them into the 'Frequency1' column. Repeat the process for your second data set and label the column 'Frequency2'.
3. Highlight your 'Frequency1' and 'Frequency2' columns and click the 'Insert' tab on the Ribbon at the top of the page. Click the 'Column' drop-down box and select the style that you want to display on your chart. Click the 'Select Data' button on the Design tab of the ribbon, click 'Edit' under Horizontal Axis Labels and highlight your Bin Range values in the Axis Label Range text box.
4. Customize your chart with the tools in the Design, Layout and Format tabs of the Ribbon. Add chart titles, axis titles and data labels from the Labels area of the Layout tab. Change the color scheme from the Design tab and customize the shape styles and colors from the Format tab.