Map Chart Troubles: 2 Seperate Problems

%3CLINGO-SUB%20id%3D%22lingo-sub-2724997%22%20slang%3D%22en-US%22%3EMap%20Chart%20Troubles%3A%202%20Seperate%20Problems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2724997%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%20I%20am%20in%20need%20of%20an%20excel%20expert%20to%20help%20me%20solve%20a%20couple%20of%20problems%20I%20am%20having%20with%20map%20charts.%20I%20have%20two%20very%20specific%20problems%20I%20am%20having%2C%20dealing%20with%20the%20display%20of%20the%20map%20charts.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EProblem%201%3A%20I%20would%20like%20to%20have%20all%20countries%20lit%20up%20that%20have%20data%2C%20then%20showing%20each%20state%20with%20data%20when%20selected%20%22states%22%20with%20a%20splicer%2C%20then%20showing%20each%20providence%20highlighted%20in%20each%20state%20when%20selected%20%22providences%22%20with%20a%20splicer.%20I%20want%20it%20to%20show%20in%20descending%20view%2C%20so%20in%20world%20view%2C%20I%20can%20see%20all%20countries%20with%20data%2C%20then%20go%20into%20the%20country%20and%20see%20all%20states%20with%20data%2C%20then%20go%20into%20the%20state%20and%20see%20all%20providences%20with%20data.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EI%20can%20make%20it%20show%20the%20country%2C%20state%2C%20or%20providence%20light%20up%20but%20not%20all%20at%20the%20same%20time%20if%20you%20know%20what%20I%20mean.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EProblem%202%3A%20In%20world%20view%2C%20some%20of%20my%20countries%20are%20not%20highlighted%20while%20others%20are.%20I%20have%20tried%20reordering%20my%20field%20lists%20several%20times%20but%20nothing%20will%20fix%20it.%20I%20know%20excel%20is%20identifying%20my%20data%20correctly%20as%20I%20can%20select%20each%20country%20in%20the%20splicer%20and%20it%20shows%20it%20correctly.%20It%20just%20isn't%20showing%20all%20countries%20highlighted%20in%20the%20world%20view%20at%20the%20same%20time.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20have%20attached%20a%20couple%20of%20files%20here%20to%20show%20you%20what%20I'm%20working%20with.%20The%20file%20Jesse%20Watson%20is%20the%20problem%20where%20not%20all%20countries%20are%20showing%20up%20on%20world%20view%20(problem%202).%20The%20file%20for%20Paul%20Lyday%20I%20am%20having%20is%20only%20showing%20the%20Providences%20and%20not%20the%20countries%20and%20states%20being%20highlighted%20at%20different%20views%2C%20such%20as%20world%20and%20country%20views%20(problem%201).%20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2724997%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2752290%22%20slang%3D%22en-US%22%3ERe%3A%20Map%20Chart%20Troubles%3A%202%20Seperate%20Problems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2752290%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20no%20longer%20having%20problem%202.%20For%20some%20reason%20my%20map%20chart%20was%20not%20auto%20selecting%20the%20larger%20data%20set%20I%20was%20using%2C%20so%20it%20was%20only%20showing%20some%20of%20the%20countries.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1147967%22%20target%3D%22_blank%22%3E%40JCOLONDCM%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, I am in need of an excel expert to help me solve a couple of problems I am having with map charts. I have two very specific problems I am having, dealing with the display of the map charts.

 

Problem 1: I would like to have all countries lit up that have data, then showing each state with data when selected "states" with a splicer, then showing each providence highlighted in each state when selected "providences" with a splicer. I want it to show in descending view, so in world view, I can see all countries with data, then go into the country and see all states with data, then go into the state and see all providences with data. I can make it show the country, state, or providence light up but not all at the same time if you know what I mean.

 

Problem 2: In world view, some of my countries are not highlighted while others are. I have tried reordering my field lists several times but nothing will fix it. I know excel is identifying my data correctly as I can select each country in the splicer and it shows it correctly. It just isn't showing all countries highlighted in the world view at the same time. 

 

I have attached a couple of files here to show you what I'm working with. The file Jesse Watson is the problem where not all countries are showing up on world view (problem 2). The file for Paul Lyday I am having is only showing the Providences and not the countries and states being highlighted at different views, such as world and country views (problem 1).

1 Reply

I am no longer having problem 2. For some reason my map chart was not auto selecting the larger data set I was using, so it was only showing some of the countries.@JCOLONDCM