The JavaScript script for DropDown1, Plan and Actual section of Sample2mod.bqy is:
var choice=ActiveDocument.Sections["Plan and Actual"].Shapes.DropDown1[DropDown1.SelectedIndex]; if (choice=='Planned vs. Actual') { ActiveDocument.Sections["PlanActualCostsChart"].Facts.RemoveAll(); ActiveDocument.Sections["PlanActualCostsChart"].Facts.Add('Costs Plan'); ActiveDocument.Sections["PlanActualCostsChart"].Facts.Add('Costs Actual'); ActiveDocument.Sections["PlanActualSoldChart"].Facts.RemoveAll(); ActiveDocument.Sections["PlanActualSoldChart"].Facts.Add('Units Sold Plan'); ActiveDocument.Sections["PlanActualSoldChart"].Facts.Add('Units Sold Actual'); ActiveDocument.Sections["PlanActualRevenueChart"].Facts.RemoveAll(); ActiveDocument.Sections["PlanActualRevenueChart"].Facts.Add('Revenue Plan'); ActiveDocument.Sections["PlanActualRevenueChart"].Facts.Add('Revenue Actual'); } else if (choice=='Planned') { ActiveDocument.Sections["PlanActualCostsChart"].Facts.RemoveAll(); ActiveDocument.Sections["PlanActualCostsChart"].Facts.Add('Costs Plan'); ActiveDocument.Sections["PlanActualSoldChart"].Facts.RemoveAll(); ActiveDocument.Sections["PlanActualSoldChart"].Facts.Add('Units Sold Plan'); ActiveDocument.Sections["PlanActualRevenueChart"].Facts.RemoveAll(); ActiveDocument.Sections["PlanActualRevenueChart"].Facts.Add('Revenue Plan'); } else if (choice=='Actual') { ActiveDocument.Sections["PlanActualCostsChart"].Facts.RemoveAll(); ActiveDocument.Sections["PlanActualCostsChart"].Facts.Add('Costs Actual'); ActiveDocument.Sections["PlanActualSoldChart"].Facts.RemoveAll(); ActiveDocument.Sections["PlanActualSoldChart"].Facts.Add('Units Sold Actual'); ActiveDocument.Sections["PlanActualRevenueChart"].Facts.RemoveAll(); ActiveDocument.Sections["PlanActualRevenueChart"].Facts.Add('Revenue Actual'); }