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

Hello all,

I managed to create a frequency diagram very easily using the data tab and then the dataanalysis function like this:

1. Copy my input data to the first column in a fresh sheet.

2. Create my own intervals.

3. Use the function above where I select my input data and intervals and voila. Very nice!

Sadly, these do not seem to be dynamic, such that when I delete data or add new data, it's not updated.

In order to create a dynamic histogram, am I dependent on setting up the bins/intervals manually and also calculating them manually?

I'm planning to create multiple sheets where I track certain statistics and I'm imagining to be updating them once every week or so, so I would like to have a solution where I can simply copy in new input data and have the histograms update themselves automatically.

Thanks in advance!

PS: Attached is the file I created using the steps above.

EDIT: http://www.excel-easy.com/examples/histogram.html

This illustrates the technique I used. Very easy, but sadly not dynamic.