Hi, I'm a student working on an assignment for intro to GIS. The assignment is asking to create two choropleth maps comparing solar fuel data to wood fuel data in U.S. counties. I downloaded the data from census.gov and created a file geodatabase where I imported the excel table, in which, I had changed the id2 column into text by using a text formula. I imported a U.S. counties polygon feature type and the excel table into my map document. I joined it by using geoid10 and id2, but when I go to create the choropleth map the map is missing data from a couple of states. I was wondering if anyone could tell me if I'm joining it wrong?