Fix Australia Displaying Too Small in an Excel Map Chart
Question details
The user needs to correct an Excel Map Chart that renders Australia at an incorrect size or identifies it as only Tasmania.

- Product
- Microsoft Excel Map Chart
- Device & OS
- not provided
- Scenario
- The user is visualizing Australian geographic data in a filled map chart.
- Observed behavior
- Australia may appear as Tasmania only or look smaller than New Zealand instead of displaying the full country.
Confirm that your data uses consistent Australian place names and includes a separate Country or Region column with the value "Australia." If available, use the Excel desktop app, because 3D Maps is not supported in every Excel edition or platform.
Refresh Excel Map Geography Through a New Workbook and 3D Maps
Use this workaround when a previously working Excel Map Chart suddenly renders Australia incorrectly despite having valid geographic data.
Opening the same data in a new workbook and exploring it in 3D Maps can refresh Excel's geographic mapping data. Afterward, the original map chart may recognize Australia correctly.
Save your work if needed, then close the affected workbook and any other open Excel windows.
Open Excel, select File > New > Blank workbook, and paste the same geographic data used by the affected map chart into a worksheet.
Select a cell in the pasted data, then go to Insert > 3D Map > Open 3D Maps. Assign the geographic location field when prompted.
In the 3D Maps window, navigate to Australia and briefly pan or zoom around the map so Excel loads the geographic area.
Close or leave 3D Maps, reopen the original workbook, and check the map chart. If necessary, select the chart and use Chart Design > Refresh Data.

Add Complete Australian Regions and an Australia Country Field
Use this method when Excel maps a location to Tasmania or another partial Australian region because the location data is incomplete or ambiguous.
Use WPS Office for Everyday Spreadsheet Charts and Visual Reports
If an Excel-specific map chart rendering issue interrupts your reporting, WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface for creating, editing, and sharing chart-based workbooks. You can open existing Excel files and continue working with common spreadsheet charts while migrating your workflow smoothly.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the app launcher.
- 2. Open the Excel workbook: Select Menu > Open and choose the XLS or XLSX workbook that contains your data.
- 3. Review your chart data: Select the worksheet data range and use the Insert tab to add or adjust a compatible chart for your report.

Frequently Asked Questions
Why does my Excel Map Chart show Tasmania instead of Australia?
Excel may resolve the location as Tasmania when its geographic matching data is incomplete or the source values lack country context. Add a Country column containing "Australia" and use complete, unambiguous region names.
Does Excel 3D Maps fix a filled map chart that displays Australia incorrectly?
It can. Create a new workbook with the same data, open Insert > 3D Map > Open 3D Maps, browse the Australian area, and then reopen or refresh the original filled map chart.
Which Australian locations should I include in an Excel map dataset?
Include the states and territories required by your analysis as separate, clearly named locations, and pair them with an Australia country value. More complete geographic context helps Excel map the data correctly.
Can I refresh an Excel Map Chart after correcting the source data?
Yes. Select the chart and use Chart Design > Refresh Data. If the revised rows are outside the current source range, use Chart Design > Select Data to update the chart's data range.




