Choose Replace All to make the replacements automatically across the document, or Replace to make only the first replacement. If you choose Replace, you’ll have to click Find Next to see the next match, and then click Replace.
As I mention in, you can’t create pivot charts in Excel for the Mac. It’s, hands down, my greatest aggravation with Excel. However, Excel for the Mac has an additional bug that renders any pivot chart created on a PC that includes a report filter utterly useless. You can see the options in the drop-down filter and even select them. In fact, the pivot table (that’s created with every pivot chart) updates.
However, your pivot chart will not update. I demonstrate this disappointing failure in this short demo. Test For Yourself Don’t believe me, Excel for Mac users?
Go ahead and test it for yourself with the pivot chart in. Learn More If you want to learn more about data visualizations that don’t suck, check out my offerings. Written by Categorized: Tagged:,.