I have PivotChart using three ActiveX combo boxes, Combo Box1 controls both Combo Box2 and Combo Box3.
When I change Combo Box1 item, set default value in Combo Box2 and Combo Box3, then change Combo Box2 and Combo Box3, get charts normal response to Combo Box1 item. It works well for chart.
The problem is the Combo Box2 and Combo Box3 increase list items.
If using “ComboBox.Clear”, a “blank value” will assign to charts.
Please give me some ideas. Thank you very much!