Legend Entries in Chart

[boonga]

I created a drop down list to display certain data based on the selected option. This was done using the filter function. I also created a chart referencing that data, so it changes along with it. However, my issue is that the chart legend entries show up for data that isn’t available for certain options in my drop down list. Is there a way to fix it so that my legend entry will only show up for data that is available based on the option I have selected from my drop down list? The drop down list has different regions of the U.S. and within those regions there will be states, counties and cities displayed.

EDIT:
For example, if I click Midwest from my drop down list, it will display a certain number of states, let’s say 6. So, there will be six legend entries in the chart to label each data point. However, if I click a different region in my list, which only has 3 states, the chart would still have the six legend entries from the region that has the most states, which for this purpose let’s say is six. Is there a way I can fix my chart so it will display the correct number of legend entries for each region?

 

[Jeffrey Mahoney]

I don't know how your formulas a set up for the states when you select a region, but if those remaining cells equate to #N/A, a chart will ignore them. If you post the formula that you are using to display the States in the region, maybe I could help.