Forum Discussion
Map 2 States with CVS data
In addition, I'd do not recommend to use rich data types (Geography), usually Map Charts works with plain text much better. Even if Microsoft recommends to use data types.
Another point you may play with series colors. Instead of default 2-level gradient in blue you may define your own colors, use 3-levels gradients and not only from lowest to highest but define levels by fixed numbers or precents. Unfortunately ther is no option with formula.
This was a nice treat lol. Thank you for your response and input. I am taking your recommendations on plain text charts, but I am having a hard time replicating. Not to be a Noobie, but I got a few questions on how you did that magic!!!
1.) How did you get the Map to show up completely? I think my environment limits my Excel in some of those action just my thought.
2.) How did you get the splitter aka. (Level) to show up? I am noobie you Jedi Master.
3.) The formula in Cell N10 how does this work with the green table?
4.) Is there a to represent the same incident that would be showing up at both sites?
All in all, thank you for your time and patience's as well. You and the community are real hero's. Rounds of coffee and beer on me!!!