We found the "idMso" for "Analyze Data". We added below to our customUI.xml and it solved our problem.
<group idMso="GroupIdeas" />
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I want to add "Analyze Data" button to my custom ribbon and access "Analyze Data" from my ribbon tab instead of Home ribbon tab. I am developing Excel addin(XLAM) for Mac environment.
In the attached screenshot:
Note: I tried using "Excel--Preferences--Ribbon & Toolbar" but not able to see my Addin tab there. Tried creating a new tab there and Add "Analyze Data" in there which is working but not able to find the code for new tab.
Excel Version: 16.72
MacOS version: Ventura 13.1 (22C65)
Community Discussion: Here
We found the "idMso" for "Analyze Data". We added below to our customUI.xml and it solved our problem.
<group idMso="GroupIdeas" />