When you create a pivot chart, the series order is automatically applied. In this example, the product categories had been manually sorted in the pivot table. In the pivot chart legend, the products are in the same order: Crackers, Snacks, Bars and Cookies.   In a longer list of items, you might like the series [...]

Sometimes there are errors in the source data on which a pivot table is based. In most cases, I like to see the errors on the worksheet, so that problems are easy to spot. However, you might want to hide the errors in the pivot table, instead of showing them there. By default, error values [...]

In some workbooks, you might want to allow users to make changes to a pivot table, but you need to protect formulas or data in other areas of the worksheet. If you protect the worksheet and enable pivot table use, users will be able to modify the pivot table, but won’t have access to other [...]

In some workbooks, you might want to prevent users from making any changes to a pivot table. You want them to see the pivot table, but not change it. However, users might need to make changes to data in other areas of the worksheet. If you protect the worksheet without enabling pivot table use, users [...]