Apologies at the outset, I haven't dug into the implications.
What would happen if you keep all the states, duplicate
it twice, and then just zoom in to the parts that you want,
then turn off the zoom tool?
Please see workbook v10.5 attached in the Forum Thread.
283565akhi_v10.5.twbx 178.9 KB
Nice idea, I hadn't thought of that! It worked well for AK and HI. I realized after posting this that I also wanted to pull out DC since you can't really see it on the map. I had to filter out Virginia and Maryland after zooming in- not ideal, but works well enough.
Thanks for the tip!
1 of 1 people found this helpful
I fear that filtering may throw off the color scale again: for example if Virginia has the max value
but has been excluded, the color for DC won't be correct.
If you are going to have to filter, I'm not sure, but I think you may
technique to do so. That way the underlying max value in Virginia, for example, will
still color the max of the scale.
Edit: I see now that you have already used that LookupFilter technique in the bar chart.
You could probably just use that on all four map sheets (continental, AK, HI, DC).
It does seem that hex method that Ken Flerlage provided the link for
makes sense for making all the states visible.
Hex maps have a lot of advantages:
1) You can put all states on a single sheet--so your scale problem won't be an issue.
2) Each state can be seen easily, including the smaller states like Rhode Island.
3) Geographically large states like Alaska and Montana are not overstated--they are shown the same size as all other states.
It may take a bit of getting used to at first, but I definitely think it's the right approach for this situation.
Hi, just following up on this one. Let us know if we can be of any further assistance.