Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi GUYS,
Can anyone help with object specific default selection.
I have six charts in a sheet(minimized state), but I want default selection for only three charts, when i click to other charts those selection should be cleared.
Hi,
Check the atatched one.
As Gysbert mentioned, the Alternate States feature may address your requirement.
Use Alternate States if you want to maintain two independent sets of selections.
Use Set Analysis if you want an expression to ignore selections in a field
{<Student=>}
-Rob
Rajashmita,
I think Alternate state is teh best option for ur problem...
Create on open triggers on the particulat alternate state which is used in the chart that needs the selection to be made..
-Sundar
Hi Rajashmita,
Consider you make default selection when open the document or sheet of particular field
assume that you have list box a c b d... here you want make default selection is c then
go to sheet properties -Triggers -On Activate-Add actions -add- Selection- select in field -Field name means you list box name and in Search String should be like 'c' .
then use clear all OnLeaveSheet .
If any clarifications let us know so that it easy for you