The drop-down lists are identical, but the format controls
are going to two different charts(tables). Is there a way
to make both of the drop-down lists show the same
selection, so I can keep both charts separate? Or can I
expand on the format control so it will select from both
charts at the same time and only keep one drop-down list?

Thank you,

Tony

<<Is there a way to make both of the drop-down lists show the same

Copy and paste the drop down (thus ensuring that the results cell is the same one).


Regards
BrianB
-------------------------------------------------



"Tony Bondar" wrote in message ...
The drop-down lists are identical, but the format controls
are going to two different charts(tables). Is there a way
to make both of the drop-down lists show the same
selection, so I can keep both charts separate? Or can I
expand on the format control so it will select from both
charts at the same time and only keep one drop-down list?

Thank you,

Tony