Use Excel Ranges for Multiple Visio Data Visualizer Pages
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.

- 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.
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.
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.
Open the Visio drawing and create a new page for the next diagram.
On the new page, select Data, then choose Create to start creating a diagram from data.
Select the Excel workbook containing the data you want to use.
Choose Custom Range and specify the Excel range for that page. Follow the remaining prompts to create the diagram.
Add each additional Visio page and repeat Data > Create, selecting the appropriate custom range for that page.

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.

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.




