To overcome this potential issue, select all the geographical items in your chart, and click "Geography" in the Data tab on the ribbon. This will force Excel to scan your selection, and either ...

The less-used data function on Excel is Geography data. The geography data feature in Excel is a goldmine with a lot of data in a click away. You can get data of a location like its population ...