Hi MJFleming, thank you for pointing out that I can link the the frequency table to the live table by cell references. I tried it, it worked very well. -Fang :)
It's worth pointing out that you can actually link the histogram frequency table to the live table by way of cell references. Then you will have a histogram which updates automatically. In fact, you could probably just write the FREQUENCY() function right into the histogram frequency table itself.
Hi MJFleming, thank you for pointing out that I can link the the frequency table to the live table by cell references. I tried it, it worked very well. -Fang :)
It's worth pointing out that you can actually link the histogram frequency table to the live table by way of cell references. Then you will have a histogram which updates automatically. In fact, you could probably just write the FREQUENCY() function right into the histogram frequency table itself.