Alas, the beautiful spreadsheet for the masses, is clearly beautiful, but just a variant of Excel.
#Histogram maker for mac software
Data distribution is an abstract concept, yet easily and instantly rendered tangible and understandable with software - sadly not with numbers. In all due respect to the experts who have responded to this question. If you want to include more than one genre simultaneously, that can be done but will require a different means to execute, using checkboxes and a more complex IF function to replace the one above. Run FREQUENCY off of that column and it will change as you change genres in your "Choose Genre Here" table. Again, either use OFFSET against your genres table, or create a drop-down list.
Now create a small table to house the genre you're wanting to get frequencies for. You might be perfectly happy using a non-dynamic drop-down list. That's been explained in other discussions, so I'll leave that alone for now. This will prevent typos and will be more dynamic should you need to add genres later. If your books table isn't already populated with hundreds of books, then I'd use an OFFSET function on your genres table to pull in the genre in your books table. 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.