Excel Combo Box Drop Down with Selects for Multiple Charts from Multiple Tables

Hello,

I am attempting to create a dynaic dashboard. I would like to use the drop down combo box that is found in the developer ribbon and have it link to three different tables that feed three different charts. I am a beginner so any help is greatly appreciated!!!

I can create the box and link it to a single table/chart, but not multiple charts.....

THANKS!