Excel: Using Slicers With Password Protected Sheets

Who doesn’t love slicers? What an awesome way to sort and filter data. We have talked about how, in addition to being a time saver, slicers can make it easier to share your data with others who are not as comfortable working in Excel. Not everyone understands, “filter the data,” but we all can understand … Continue reading “Excel: Using Slicers With Password Protected Sheets”

Excel: Filter a Pie PivotChart and Maintain Percent of Whole (A Different Take on Progress Charts)

A fantastic question came up during last week’s open lab. Is it possible to create a PivotChart pie chart that can be filtered to show only the percent of the item selected?  Here is one solution for that question (and spoiler alert, it is technically not a PivotChart). A few things before we get started… … Continue reading “Excel: Filter a Pie PivotChart and Maintain Percent of Whole (A Different Take on Progress Charts)”