Data Import & Export

Use Excel Ranges for Multiple Visio Data Visualizer Pages

Adam DavisAdam Davis Nov 14, 2026 868 views

Question details

The user wants to use Excel data to create Data Visualizer diagrams on multiple Visio pages without requiring a separate table for each page.

Use Excel Ranges for Multiple Visio Data Visualizer Pages
Product
Microsoft Visio Data Visualizer
Device & OS
not provided
Scenario
A workflow spans multiple Visio pages, with each page using a selected range from an Excel workbook.
Observed behavior
The desired result is a separate Data Visualizer diagram on each page using the relevant Excel range.
Before you start

Prepare the Excel workbook with the Data Visualizer columns and identify the range you want to use for each page. Check that Data Visualizer is available in your Visio version.

Solution 1Recommended

Select a custom Excel range for each Visio page

Use this approach to create diagrams on separate pages without creating a separate Excel table for every page.

1
Add a page

Open the Visio drawing and create a new page for the next diagram.

2
Start Data Visualizer

On the new page, select Data, then choose Create to start creating a diagram from data.

3
Choose the workbook

Select the Excel workbook containing the data you want to use.

4
Select the page range

Choose Custom Range and specify the Excel range for that page. Follow the remaining prompts to create the diagram.

5
Repeat for other pages

Add each additional Visio page and repeat Data > Create, selecting the appropriate custom range for that page.

Select a custom Excel range for each Visio page
Page-splitting limitation: Data Visualizer does not provide an automatic setting to split a single flowchart across pages. If the source data changes while the workflow is being developed, review the selected ranges and page diagrams as needed.
Free Microsoft Office alternative

Prepare Excel Data Visualizer Workbooks in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for preparing and editing spreadsheet data. Its Excel format compatibility makes it easy to move workbook data between WPS Spreadsheets and Microsoft Office. Visio is still needed to create Data Visualizer diagrams.

Edit the source rows and columns used for Data Visualizer diagrams.Open and save Microsoft Excel XLSX workbooks for use in Microsoft Office.Work in a familiar spreadsheet interface for an easier transition.Use a free, lightweight office suite for everyday document tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Does every Visio page need a separate Excel table?

No. On each page, use Data > Create, select the workbook, and choose Custom Range to specify the data for that page.

Can Data Visualizer automatically split one flowchart across pages?

Data Visualizer does not provide an automatic page-split setting for a single flowchart. Create the pages separately and select the relevant Excel range for each one.

What if the Excel data changes as the workflow develops?

Review the custom ranges and the resulting Visio page diagrams when the source data changes. A fixed range may need to be adjusted if new data falls outside it.

Can WPS Office create a Visio Data Visualizer diagram?

WPS Spreadsheets can prepare and edit the Excel workbook, but creating a Visio Data Visualizer diagram requires Visio.