First select one value in the multi listbox, and then
Chart Properties -> Presentation -> Select Dimension -> Select "Always One Selected value"
Hope this helps you.
Hope attached image helps you.
test.PNG 31.1 K
1. Click tools and Edit module and place this code
SET Week_Ending_field = ActiveDocument.Fields("Week_Ending")
SET Week_Ending_values = Week_Ending_field.GetSelectedValues
if Week_Ending_values.count>0 then
ChosenValue = Week_Ending_values(0).Text '
Select the first / lowest
2. Make sure you change the field name to what your field name is
3. Settings>>>Document Properties>>>Triggers>>>Field event Trigger area and select your field name
4. add on select action
5. to run macro and call this macro that you added above..
works like a charm... good for list boxes etc as well..