Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video I explain how to create an interactive or dynamic histogram chart. The number of groups in the histogram can be set by the user with a scrollbar control on the worksheet.
Download the Excel file: https://www.excelcampus.com/charts/dynamic-histogram/

This video is also for Excel Hash. This is a contest with other Excel YouTube channels, and is similar to popular TV cooking shows like Chopped. We were given 4 main ingredients (Excel features) and had to create a solution around those features.

The 4 ingredients are:
1. MAX function
2. FREQUENCY function
3. Form Control
4. 3D Model

The dynamic histogram chart uses all of these ingredients to calculate the chart's data with formulas, and made it interactive. I added the 3D Model of Clippy to provide information about the chart, and add some fun to the sheet.

Please watch the other entries for Excel Hash at the following playlist: https://www.youtube.com/playlist?list=PLHrPHBbDHgT0UnY1qb36YZrBwpWNJX8Lx

Please VOTE for your favorite at the following link: https://www.excelcampus.com/excel-hash-voting


Related Videos:

Enable the Developer Tab: https://youtu.be/JLQ8OuW0FlY

Array Formulas: https://youtu.be/I23Cy8FkMLY

Pivot Tables & Dashboards: https://youtu.be/9NUjHBNWe9M
00:00 Introduction
01:33 Chart Setup
04:46 Dynamic Named Rangers
06:52 Scroll Bar Control
08:46 Clippy