Is there an easy way to create dynamic histograms/frequency diagrams?

I may add that I'm creating frequency diagrams of data that is not numerical as well. For instance, I have a statistic with two parameters, "LH" and "HL".

With this type of data, I couldn't use the function I utilized above anyway since it wasn't numerical, so I solved it by setting up two intervals "LH" and "HL".

Then, I used the COUNTIF function and managed to count the occurrence of each such that I have the frequency. Now, I could easily make a diagram.

And this one seems to be dynamic!

I guess this solves my problem in the first post, but I have a hard time doing the counting when the intervals I set up contain more than one type of value. In those instances, I suppose I would need to find a way to count values greater than/equal to 09:31 and less than/equal to 10:00. For example.

I like how the function in the first post counts the frequency according to my pre-defined intervals.

humdingaling,

Thank you very much!

I like your second sheet, DayLow, the best due to simplicity.

I suppose my general solution for this and my other sheets would be to:

1. Input my data in the far left column.

2. Create my own intervals/bins according to my own criteria.

3. Count the frequency in my input data for each interval.

This is in essence what you've done, right?

My challenge then seems to be understanding or mastering the function you're using to count for each interval. Would you care to explain or give me a link where I can understand this formula?

Here's a similar challenge.

I'm here looking at daily price changes. These range from roughly -4% to +4%. I'm considering perhaps making one sheet for positive changes and one sheet for negative changes. But probably it's best if I can combine them.

So, I set up the proposed intervals I imagine may be suitable.

I'm not sure if I should include change = 0% as one single value or if I should include 0% in the first positive interval ranging from 0-1%. Maybe that is better. Then the first negative interval would be from less than 0 to -1%.

Regardless, the challenge for me is to be able to count each occurence inside each interval. I suppose I may make use of the same formula as you suggested in the first sheet?

Thanks again.

Thank you very much, humdingaling! : )

The way you defined the bins is exactly what I had in mind. I will just have to learn how to perform the count function myself. I hope it's okay to ask if I'm stuck.

Thanks again.

Hello again,

I think I mastered the count function for my purposes. In fact, I've already made quite a few new sheets. So, thanks again! : )

While working with this, I decided it would be interesting to see the frequency for when BOTH the DayLow and DayHigh occur inside the same interval. Attached is a sheet with High & Low data side by side.

I suppose the rest of the sheet may be ignored (it's actually a copy of my Day Low sheet with the DayHigh added).

Maybe this isn't too hard, but right now, I'm thinking it might be kind of advanced. Not quite sure how to attack this problem.

I'm thinking like this:

1. I imagine that this is a rare occurence. So, we need to eliminate or ignore all the data where the DayLow & DayHigh is not in the same interval.

2. Now, count the occurence of each like done earlier. If we somehow can delete/ignore all data which is not in the same interval, this step should be easy as we can count only one of the columns.

But perhaps these two steps can be combined.

If this is too advanced, I may decide to drop it. : )

EDIT: As it is now, the DayHigh & DayLow is paired data, so it's for the same day.

Thank you very much for your sheet. If I'm not mistaken, what you've calculated is whether the Low precedes the High for each day. Right? Actually, it's a useful statistic that I track elsewhere, but not exactly what I meant.

Here's one day with Low and High side-by-side:

09:35 | 15:45

Here, it's clear that the Low is slotted inside the 10:00 interval and that the High is slotted inside the 16:00 interval. So, they happen in separate intervals, right?

Here's another day:

09:31 | 09:55

Here, we can see that both the Low and High (sequence isn't important as it could be the other way around) for the day occurs inside the same interval.

What I wanted to find out is how often this happen for each interval. Not quite often, I imagine, but it would be interesting to know.

Fantastic, humdingaling! : )

That's exactly what I meant other than me wanting to plot it differently, but that's easy for me to figure out myself.

The only problem is that when I "activate editing" since it's a downloaded file, I get the error #value! for the column C with the long If analysis formula. I'll see if I can figure it out.

Thanks again.