The FREQUENCY() function will recalculate when data changes and this can be used to create a histogram that is always representing the current values (unlike the histogram tool).