Thank you Nick M
That's really good solution, but I wasn't much clear, If I have had only regions it's perfect, but I also have Names of Sales people on the second list and they are too much to put in macro and also to make such a big option box. I'm using drop-down lists.
Any other Idea? :)...
Hello,
I need your help, I'm making drop-down lists on charts, so when I choose ALL in the list the chart shows information about 4 regions and the series' names are: Americas, EMEA,....
When I want to choose only one region in a list for instance Americas I could manage to hide the name of...