Not sure if this is possible, but I have a Combination Chart showing 1 set of values as bars on the Y-Axis and a second set of values as lines on the secondary Y-Axis. I am able to use 1 combo box to affect just the bars on the combination chart but not the lines (secondary Y-Axis) as well. Is this even possible or would I need a 2nd combo box? Basically I am able to set a Destination range in the combo box properties for my 1st Y-Axis but can't set a seperate destination range for my other set of filtered data for my 2nd Y-Axis.
Any help would be appreciated, thanks!