But if you’re creating a pivot chart, and there’s the chance that anyone might have to access it from a Mac, you cannot use report filters. You can see this epic fail in action here. (Boo hiss!!!) But not only can you not create one, you can’t even use a report filter on the Mac. You can’t create a pivot chart in Excel 2011 for Mac. Much to my chagrin, pivot charts are PC swim only. Feel free to kick it around and test out some of the filters I demonstrate in the video. If you’d like to download the Excel file I used, you can access it here. Click for larger image Download Excel File I promised a commenter I would create a follow-up video demonstrating how I took those data sets and created a pivot chart that updated when you choose a new category. In a post I wrote last week, I demonstrated in a video how to use advanced filters (one of Excel’s best-kept secrets) to divide a list of keywords into categories.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |