Lay out your data in the following format:
Start by inserting a new blank chat. Do not select any data. I would suggest using a column chart for this. Just go to
2D Column. It should be blank:
Design tab of the
Chat Tools section of the Ribbon, click on
Select Data. Under legend entries, click
Select the Series Values box (not the "Series Name" box), and click+drag to select all of the data in the frequency column.
Click OK. Now, back in the Select Data dialog, click
Edit on the "Horizontal Axis Labels".
Click+drag to select the Category column:
Now click OK on everything and set whatever other legend, title, and other settings you wish!