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?
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?
Last edited by a moderator:
