Change category axes from drop down selection
 

Can I change the category axes for a chart linked off of what is chosen in
the drop down? I have a list of region-area-individual stores, and I want to
chart the individual stores when I chose an area. all of the area's when I
choose a region, etc. Is there a way to autopopulate the chart axes to do
that simply by selecting a drop down reference?