I agree with you. Connecticut has recently updated their county level boundaries to "planning regions". However, there is still the issue of adequately mapping these "planning regions" in Excel filled maps. Please take a look at the snapshot, the new Connecticut planning regions are not recognised by Microsoft excel tool as "valid" geographies. As a result, nothing gets mapped for the state of Connecticut now.
Please note: the first region "Capital Planning Region, Connecticut" has been incorrectly mapped to "Washington DC" by the tool which is also not right. (I think its because the region name has the word "Capital" in it".)
Kindly review the issue: Anonymous (Below are the snapshots for your reference as well as source links)
Snapshot from my worksheet. First colum is the original name of planning county in CT. Second column is the same data converted in Geography format.
Map of CT "Planning Regions" published by American Community Survey Website (Link Below).
Source:
| https://data.census.gov/map/040XX00US09$0500000/ACSDT5Y2022/B25040/B25040_002E?q=house%20heating%20fuel&layer=VT_2022_050_00_PY_D1&palette=Blues&loc=41.5031,-72.8402,z8.4095 |
The above map has been created by American Community Survey website using the US Census Bureau (2022 TIGER/Line® Shapefiles: Counties (and equivalent)). Link for the same is below.
| https://www.census.gov/cgi-bin/geo/shapefiles/index.php?year=2022&layergroup=Counties+%28and+equivalent%29 |