Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Pie Chart in which I show three dimensions as a cyclic group.Now,What I need is I need to capture as to which particular dimension has
been clicked.I want to capture the Label given for the dimension corresponding to the dimension for which I am presently viewing the pie chart.
Please let me know as to how can I achieve this.
=GetCurrentField([GroupFieldName])
=GetCurrentField([GroupFieldName])
Hi,
Below code will give you the name of the dimension selected in group.
Sub Get_Dim
groups=ActiveDocument.GetGroups
set fld = groups(0).GetActiveField
msgbox fld.name
End Sub
Regards,
Kaushik Solanki
Hi,
I did do whatever Mr Kaushik and Mr Gregor suggested.
Gregor,
My Cyclic Group name is Type Group so can I add [Type Group] in the place of [GroupFieldName].
Kaushik,
Do let me know as to where can I add this Macro.Do I need to add it on all fields present in the cyclic group.
Regards,
Navin Gorapalli
Hi,
Go to the Module by Ctrl + M
Click test and then ok
Create a button. Add action -> external -> run macro -> give the macro name as Get_Dim.
Click Apply.
Click on button to check the result.
Regards,
Kaushik Solanki
Hi,
Please see the attached file. The title will change based on your field in the Group. HOpe this is what you are looking for.
Thanks,
Sharma
Hey Guys,
Thank you for all your help.I have gone with what Gregor had told me and it worked.
Solanki,
Thanks for giving in your valuable inputs.Even your Code worked but in whatever discussions I came acoss people have advised not to use a macro if possible.
Regards
Navin Gorapalli
Hi Navin,
I see that it is solved. Give Gregor's answer as answer and Solanki the helping points..
So that it can be used by others in forum, if they have similar question and also thread can be closed.
Just a suggestion.
Edit: Oops.. I see that you already did it..
Regards
Sravan
Thanks Looking for same solution