Chart & Visualization Issues

Fix Australia Displaying Too Small in an Excel Map Chart

Steven ParkerSteven Parker Nov 12, 2026 869 views

Question details

The user needs to correct an Excel Map Chart that renders Australia at an incorrect size or identifies it as only Tasmania.

Fix Australia Displaying Too Small in an Excel Map Chart
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.
Before you start

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.

Solution 1Recommended

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.

1
Close open Excel workbooks

Save your work if needed, then close the affected workbook and any other open Excel windows.

2
Create a workbook with the same data

Open Excel, select File > New > Blank workbook, and paste the same geographic data used by the affected map chart into a worksheet.

3
Open the data in 3D Maps

Select a cell in the pasted data, then go to Insert > 3D Map > Open 3D Maps. Assign the geographic location field when prompted.

4
Explore the Australian map

In the 3D Maps window, navigate to Australia and briefly pan or zoom around the map so Excel loads the geographic area.

5
Return to the original chart

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.

Refresh Excel Map Geography Through a New Workbook and 3D Maps
Map display restored: If Australia now displays as the full country, the issue was likely caused by stale or incomplete map-geography rendering in the original workbook.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the app launcher.
  2. 2. Open the Excel workbook: Select Menu > Open and choose the XLS or XLSX workbook that contains your data.
  3. 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.
Create column, line, pie, bar, and other standard charts for spreadsheet reports.Open and edit Microsoft Excel XLS and XLSX workbooks with strong format compatibility.Use a familiar ribbon-style interface for an easier transition from Microsoft Office.Work with a lightweight, free office suite for everyday data analysis and visualization.
microsoft office alternative - wps office

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.