Others

How to Add Pipe Length to a Visio Pipeline Report

Huda Qurayshi Oct 10, 2026 869 views

Question details

The user needs to include pipe length values in a Visio pipeline report, as the data appears in Shape Data but isn't readily available for report extraction.

How to Add Pipe Length to a Visio Pipeline Report

Product: Microsoft Visio
Device & OS: not provided
Scenario: Creating or modifying a pipeline report in Visio where the length of the pipes needs to be extracted dynamically from the shape geometry.
Observed behavior: Pipe length is visible in Shape Data but remains unavailable for selection when generating or modifying reports.

Before you start

Ensure you have your Visio pipeline diagram open and verify that the Developer tab is enabled so you can access the ShapeSheet for your objects.

Solution 1Recommended

Use the PATHLENGTH Formula in Shape Data

Calculate the pipe length directly from the shape's geometry using a ShapeSheet formula so it can be extracted into your reports.

By using the PATHLENGTH function, you can dynamically calculate the length of a pipeline shape based on its drawn geometry. This ensures accurate reporting directly tied to the visual diagram.

Open the ShapeSheet

Right-click the pipeline shape in your Visio diagram, navigate to 'Show ShapeSheet' (requires Developer mode enabled).

Locate Shape Data Section

Scroll down to the 'Shape Data' section in the ShapeSheet. If it does not exist, insert it by clicking 'Insert' in the ShapeSheet Tools Design tab and checking 'Shape Data'.

Enter the PATHLENGTH Formula

In the Value cell of your Pipe Length property row, enter the formula PATHLENGTH(Geometry1,Path).

Convert Units to Feet

If the default result is calculated in inches and your report requires feet, modify the formula to divide by 12, entering PATHLENGTH(Geometry1,Path)/12.

Generate the Report

Close the ShapeSheet and run your Visio report again. The computed Pipe Length property will now be available as a data field for your report.

Use the PATHLENGTH Formula in Shape Data

Unit Settings Checklist: Always confirm your diagram's page unit settings and test the generated report output with a few representative pipeline shapes to ensure the calculation and unit conversions are accurate.

Free Microsoft Office alternative

Looking for a Lightweight Diagram and Office Alternative?

While Microsoft Visio handles complex pipeline shape geometry, WPS Office offers a free, lightweight alternative with powerful flowchart, presentation, and document creation tools. Enjoy high compatibility with Microsoft Office formats in an intuitive workspace.

1. Download WPS Office: Visit the official WPS Office website and download the free installer for your operating system.
2. Install the Software: Run the installer and follow the on-screen instructions to set up the suite on your device.
3. Start Creating Diagrams: Open WPS Office, select the Flowchart or Presentation module, and start visualizing your ideas immediately.

Free, lightweight, and fast installation on multiple platformsFully compatible with Microsoft Word, Excel, and PowerPoint formatsBuilt-in flowchart and diagramming tools for everyday workflowsFamiliar, tabbed user interface for easy multitasking and quick migration

microsoft office alternative - wps office

Frequently Asked Questions

Why is my shape data not appearing in the Visio report?

Shape data might not appear if it relies on a local background calculation that hasn't been exposed as a formal Shape Data property. Ensure the property row is explicitly defined in the Shape Data section of the ShapeSheet so the reporting engine can read it.

How do I access the ShapeSheet in Visio?

To access the ShapeSheet, you must first enable Developer Mode. Go to File > Options > Advanced, and under the General section, check 'Run in developer mode'. Afterward, right-click any shape and select 'Show ShapeSheet'.

Can I change the default measurement units in my Visio diagram?

Yes, you can change the default units by navigating to the Design tab, clicking the Page Setup dialog box launcher, and selecting your preferred unit in the Page Properties tab.

Office Quick Solutions