I'm making a couple of assumptions here: (1) the actual spreadsheet you're working with contains far more granular data than you show in your example (2) you're enough of a power user that you don't need more help in developing those supplemental columns that either Sergei or I have suggested. IF you only want to display results for any given Mon-Fri period, I'd suggest using one or more of the date functions to create a "helper column" that reads from 1 to 52, so that the data for any given day gets funneled into the appropriate week, and use that WeekNum column as the filter your users can select. You mention selecting a standard work week, Mon-Fri. Unless, that is, one of your mandates is to be less flexible than the Timeline allows. So although it might be easier to let users select a start and end date, I'm not convinced you'd be doing them any favors. And I'm going to be looking for opportunities to use it myself. Excel has introduced a LOT of new features since then, and Timeline (as you've deployed it here) is one of them.]Īnd I think it-Timeline- looks amazing, and easy to use. Used to read the manuals, and was for the time a "power user", up until when I retired in 2002. Going to confess my own ignorance here: I'd never seen that Timeline capability before.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |