Requesting suggestions for data visualization? Currently using histograms. File attached.

Hi all,

I'm analyzing various stuff of data and I find that it can be nice to have visualizations to perceive both what's normal and what's happening in the data. Both recently and for "all" history.

What I have been doing is to basically do a frequency count based on my custom made bins. It might be that my bins could have been a bit smaller on this particular example. Then, I make histograms based on this frequency count. I've set things up such that I can adjust the lookback period in cell B3.

Is this the way to go about doing this? Are there better ways to visualize this type of data?

This particular example is the closing price of a stock I'm watching.

I'm attaching both the file and also a picture.

Very open to suggestions on how to proceed with all this or if what I'm doing is perhaps not too bad in the end.

Best regards and thanks!