How do I create a histogram in excel with grouped bars?

I have transaction data I am trying make a histogram from. I want to group the data by account description (ex: small tools), but for that account I also want to show the total transactions (sum) for each individual that made a transaction in that account.

How do I create this chart?

1 Answer

To create a Histogram in Excel:

1. Select the entire dataset.
2. Click the Insert tab.
3. In the Charts group, click on the 'Insert Static Chart' option.
4. In the HIstogram group, choose the one you need and click on the Histogram chart icon.