My solution (which includes a little more than you wanted, but it's how I roll) is:įirst create a simple 1-column table listing your Genres. The problem, I believe, is that when you filtered your data, you only filtered the DISPLAY of the data, not what data was still in the table. I think it may be possible to modify the formula to only count the frequencies of entries that match a criteria, but if so I can't figure it out. What I wanted was a histogram showing only the borrowing times for mysteries.
I used the method above to make a histogram and it worked nicely, but when I filtered the data table ti display only the Mystery books, the histogram didn't change. My data table has two columns, one for the genre and one for the number of days borrowed.
Is there a way to dynamically filter the data and have the histogram change, or will I have to make separate histograms for different situations?Īs an example, suppose I am tracking the borrowing time for different library books.
I'm assuming that the Reorganize Panel only filters what is displayed, and so the functions in my secont spreadsheet aren't affected. When I use the Reorganize Panel to filter my original data table (by a column I'm not counting), my histogram doesn't change.
