Pivot Chart & Find/Replace - Excel 2019 for Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-2241465%22%20slang%3D%22en-US%22%3EPivot%20Chart%20%26amp%3B%20Find%2FReplace%20-%20Excel%202019%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2241465%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BI%20have%20Excel%202019%20for%20Mac%20and%20have%20two%20questions%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20How%20do%20I%20create%20a%20Pivot%20chart%20that%20is%20a%20combo%20chart%20with%20ability%20to%20choose%20the%20types%20of%20charts%20to%20include%3F%20In%20my%20Excel%2C%20I'm%20only%20able%20to%20choose%20from%203%20different%20Combo%20pivot%20charts%20from%20the%20top%20bar%20menu.%20In%20Excel%20for%20Windows%2C%20I'm%20able%20to%20create%20combo%20chart%20and%20choose%20from%20all%20types%20of%20charts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20How%20do%20I%20use%20find%2Freplace%20to%20remove%20words%20in%20bulk%3F%20When%20I%20use%20Find%2C%20I'm%20able%20to%20find%20the%20words%20but%20if%20the%20Replace%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2241465%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%202019%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

0 Replies