Legend Entries in Chart

boonga

New Member
Joined
Dec 30, 2024
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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?
 
Last edited by a moderator:

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
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.
 
Upvote 0

Forum statistics

Threads
1,226,222
Messages
6,189,706
Members
453,566
Latest member
ariestattle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top