Requesting help to create (dynamic) histogram - Do I need to create bins for this one?

Hi, all. Merry x-mas!

I keep some statistics on a per day basis which I'd like to sum up by the end of the week. Finally, I'd like to display this (Swing Size) visually as a histogram.

I'm attaching an Excel sheet that I hope is self-explanatory. First, you have columns per each day of the week. Finally, a weekly summary.

What I'm interested in is the distribution of number of swings at suitable intervals. If not done automatically in Excel, I imagine 2,5 point intervals should be okay. Maybe 5.

Ideally, I'd have a histogram that could dynamically access the data in columns B, F, J and N, automatically create suitable bins and display the data as a histogram. Dynamic since the number of swings ain't static.

The more cumbersome workaround I'd imagine be to:

1) Copy and paste data for each single day in a "summary" column like I've done in column U.

2) Define bins. I used 2,5 point intervals here. Count frequency for each bin.

3) Create histogram based on bin size and frequency.

I'm attaching a sheet. I did a fast attempt at the 'cumbersome' solution.

Ideally, I'd just have a similar histogram that updates automatically based on the content in columns B,F,J and N, but I imagine this might not be very easy to accomplish?

Thanks in advance for any help!

Elijah

I went with the 'cumbersome' solution. It should work for me.