Forum Discussion
Solved
Trouble with Map Graph
Hi everyone,
I'm trying to create a map chart of Argentina in Excel, but I'm running into a few issues:
- "La Rioja" shows up way too far north.
- "San Juan" is missing completely (it should be near where "La Rioja" is supposed to be).
- The Argentine Antartica is being included as part of "Tierra del Fuego", but I don't want it to appear at all.
Is there a way to fix this or properly format the data so the map renders correctly?
Here's my data table and a screenshot of the graph:
If I remove "La Rioja" and "Tierra del Fuego" from the data table, the rest of the map fits perfectly in the graph area. But of course, I want to include all the provinces in my data.
I also tried pasting the data table in this post, but the forum gives me an error about invalid HTML tags (like <div>, <li>, etc.), so I couldn't include it.
I'm not familiar with Argentina geography, took provinces from wiki, and it looks like map works
Perhaps you may share your file, or play with attached if it works in your environment.
4 Replies
I'm not familiar with Argentina geography, took provinces from wiki, and it looks like map works
Perhaps you may share your file, or play with attached if it works in your environment.
Having the country name and the provinces in separate columns fixed the issue with displaced and missing provinces. However, Antarctica still appears because "Tierra del Fuego" is officially called "Province of Tierra del Fuego, Antarctica and South Atlantic Islands".
I tried using "Island of Tierra del Fuego", but it didn't work.
Your chart works fine when I open the file, but if I try to create a new chart using the same table in the same file, Antarctica is still included.
Problem with La Rioja was - Filled Map recognizes it as same name province in Spain. Country column helps it to make correct choice. Also it could be fixed if to use "La Rioja province. Argentina" (not "La Rioja. Argentina" )
Why Antarctica is shown with Tierra del Fuego I don't know. I've seen the cases when Filled Map shows different results on different versions of Excel, even if data is processed on Microsoft servers. Just in case, my map was done on Current channel, same result is on Beta channel. Same if use for provinces geography data types.
Have no idea what to do else to fix that issue.
Please considering this as well:
1. Verify Data Formatting – Ensure that province names match Excel's recognized geographic names. Sometimes, slight variations in spelling or formatting can cause misplacements.
2. Use Country and Province Columns – Try adding a separate column for "Argentina" alongside the province names. This can help Excel correctly identify locations.
3. Adjust Map Projection – Excel's map charts sometimes use different projections that can distort locations. If possible, experiment with different map types.
4. Remove Unwanted Regions – If Argentine Antarctica is being included incorrectly, check if there's an option to exclude it or manually adjust the dataset.
