Pivot Chart & Find/Replace - Excel 2019 for Mac

Hi Everyone,

I have Excel 2019 for Mac and have two questions:


1) How do I create a Pivot chart that is a combo chart with ability to choose the types of charts to include? In my Excel, I'm only able to choose from 3 different Combo pivot charts from the top bar menu. In Excel for Windows, I'm able to create combo chart and choose from all types of charts.


2) How do I use find/replace to remove words in bulk? When I use Find, I'm able to find the words but if the Replace

Bump for help

bumping this up!