How to Create a Data-Driven US States Map in Visio
Question details
The user needs to create a US states map that dynamically displays regional totals based on data, and updates those totals when states are reassigned to different regions.
- Product
- Microsoft Visio
- Device & OS
- not provided
- Scenario
- Visualizing geographic data, such as mapping membership numbers or voting populations by state and aggregating them into dynamically changing regional groups.
- Observed behavior
- Native dynamic mapping requires custom setup because the former Visio Maps add-in is discontinued, requiring manual importing of SVG maps and linking shape data to Excel spreadsheets.
Prepare an Excel spreadsheet containing your state data, specific values (like population or membership), and assigned regions, as this will act as the data engine for your Visio map.
Import an SVG Map and Link Data to Shapes
Use a scalable vector graphic (SVG) map, convert it into standard Visio shapes, and link them to an Excel file to enable data-driven regional totals.
Since the Visio Maps add-in is no longer supported, the most reliable method for creating a custom data-driven map is importing a vector map and utilizing Visio's Data Link functionality.
Search online for a royalty-free map of the US states in SVG format and download it to your local drive.
Open Visio, go to the 'Insert' tab, click 'Pictures', and select your downloaded SVG file to place it on the canvas.
Right-click the imported SVG map, select 'Group', and click 'Ungroup'. This converts the vector paths into individual Visio shapes for each state.
Right-click a state shape, navigate to 'Data', and select 'Define Shape Data'. Create fields matching your Excel columns, such as 'State Name', 'Region', and 'Population'.
Go to the 'Data' tab and click 'Custom Import' (or 'Quick Link'). Follow the wizard to connect your prepared Excel spreadsheet. Drag and drop the data rows onto their corresponding state shapes to link them. Regional totals will update based on Excel calculations.
Use Built-in Visio US State Stencils
Search the built-in Visio library for standard US state shapes if you prefer not to use external SVG files.
Enhance Your Data Visualization with WPS Office
While creating custom data-driven maps in Visio can be highly complex and requires manual data linking, managing your data sets doesn't have to be. Switch to WPS Office as a complete, lightweight alternative to Microsoft Office. With WPS Spreadsheets, you can easily organize your state and regional data, utilize powerful pivot tables, and create dynamic data charts in an intuitive interface.
Frequently Asked Questions
Is the Visio Maps add-in still available?
No, Microsoft no longer supports the Visio Maps add-in. Users now need to import SVG maps and utilize the Shape Data and Custom Data Import tools to link map graphics with external Excel data.
Can Visio automatically calculate regional totals when I group states?
Visio does not natively perform dynamic regional calculations just by grouping shapes. To display regional totals, you must perform the aggregation calculations in a connected Excel spreadsheet and import those results into your Visio data graphics.
Where can I find a US states map compatible with Visio?
You can search for state shapes in Visio's built-in Shape search, or you can download any standard vector-based SVG map of the US online. Visio imports SVG files well and allows you to ungroup them into standard shapes.
How do I dynamically reassign states to different regions on the map?
You should change the region assignment in your linked Excel spreadsheet. Once saved, refresh the data connection in Visio (Data tab > Refresh All). This will update the Shape Data and visually change the region if you have set up Color by Value data graphics.
