Microsoft Excel allows you to enter data into a spreadsheet and then create a histogram. Enter the title of your different x-axis values. For example, assume you count animals at the zoo. You have lions, zebras and bears. In cell A1, type Lions. In cell B1, type Zebras, and type Bears in cell C1. Type the frequency of the values in the row underneath them. In the example, if there are four lions, five zebras and eight bears, type 4 in cell A2, 5 in cell B2 and 8 in cell C2. Highlight your data. Click the Insert tab. Select Column. The graph will now appear on your spreadsheet.

Microsoft Excel allows you to enter data into a spreadsheet and then create a histogram. Enter the title of your different x-axis values. For example, assume you count animals at the zoo. You have lions, zebras and bears. In cell A1, type Lions. In cell B1, type Zebras, and type Bears in cell C1. Type the frequency of the values in the row underneath them. In the example, if there are four lions, five zebras and eight bears, type 4 in cell A2, 5 in cell B2 and 8 in cell C2. Highlight your data. Click the Insert tab. Select Column. The graph will now appear on your spreadsheet.