• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • SS Plus
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • VRA makes the case for Prudential
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • Articles➡
      • ShapeSheet Functions A-Z
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • Key differences between the Visio desktop and web apps
      • Using the Visio Data Visualizer in Excel
      • Using Visio in Teams
      • Creating Visio Tabs and Apps for Teams with SharePoint Framework (SPFx)
      • Designing Power Automate Flows with Microsoft Visio
      • Innovative uses of Visio Lists
    • Webcasts ➡
      • Visio in Organizations
      • My session and other Visio sessions at MSIgnite 2019
      • Power up your Visio diagrams
      • Vision up your Visio diagrams
      • The Visio 2010 MVP Sessions
    • Visio Web Learning Resources
    • Books➡
      • Mastering Data Visualization with Microsoft Visio
      • Microsoft Visio Business Process Diagramming and Validation
      • Visualizing Information with Microsoft Visio
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • Visio blog on Orbus website
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Website Privacy Policy
    • Website terms and conditions
    • Ariba Network
You are here: Home / Visio / A Page Grid with Labels

Published on October 18, 2012 by David Parker

A Page Grid with Labels

Over a year ago, I wrote a blog about Page Grids and Off Page References ( see http://blog.bvisual.net/2011/09/02/page-grids-and-off-page-references/ ), and I promised to accommodate page margins. In addition, a user commented that a matching printable grid would be useful …. so here is an update. In this blog I provide an updated Off-page reference master, along with new GridLines and GridLabel masters.

image

The GridLines master uses the same page Shape Data rows that were described in the previous blog. and automatically displays the correct number of column and row lines (maximum 26 each), leaving out the page print margins.

The GridLabel master calculates the Row and Column that it is within, and you can choose whether to display the Row and/or Column labels. I have made the GridLabel shape to be separate from the GridLines shape, so that you can place them wherever you like.

The formula for Prop.Row is:

=GUARD(INDEX(IF(ThePage!Prop.BottomToTop,INT((PinY-ThePage!PageBottomMargin)/((ThePage!PageHeight-ThePage!PageBottomMargin-ThePage!PageTopMargin)/ThePage!Prop.NumberOfRows)),ThePage!Prop.NumberOfRows-1-INT((PinY-ThePage!PageBottomMargin)/((ThePage!PageHeight-ThePage!PageBottomMargin-ThePage!PageTopMargin)/ThePage!Prop.NumberOfRows))),ThePage!Prop.RowHeaders))

And Prop.Column is:

=GUARD(INDEX(IF(ThePage!Prop.LeftToRight,INT((PinX-ThePage!PageLeftMargin)/((ThePage!PageWidth-ThePage!PageLeftMargin-ThePage!PageRightMargin)/ThePage!Prop.NumberOfColumns)),ThePage!Prop.NumberOfColumns-1-INT((PinX-ThePage!PageLeftMargin)/((ThePage!PageWidth-ThePage!PageLeftMargin-ThePage!PageRightMargin)/ThePage!Prop.NumberOfColumns))),ThePage!Prop.ColumnHeaders))

You can download PageGridWithMargins.vsd from here : http://sdrv.ms/VaMc0f

Related

Filed Under: Visio Tagged With: Shape Data, ShapeSheet Functions

About David Parker

David Parker has 25 years' experience of providing data visualization solutions to companies around the globe. He is a Microsoft MVP and Visio expert.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Visio ShapeSheet Functions G-K
  • Two Quote or Not Two Quote …
  • Visio in Organizations
  • Viewing Visio Document Changes in Git
  • Visio ShapeSheet Functions D-F

Categories

Tags

Accessibility Add-Ins Connectors Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript Layers Legend Link Data to Shapes MSIgnite Office365 Org Chart PowerApps PowerBI PowerQuery Processes Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint SharePoint 2013 SQL Teams Themes Validation VBA Video Visio Visio 2007 Visio 2013 Visio for the Web Visio Online Visio Pro for Office365 Visio Services Visio Viewer Web Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • LinkedIn
  • Twitter

Search this website

Recent posts

  • Visio ShapeSheet Functions G-K
  • Two Quote or Not Two Quote …
  • Visio in Organizations
  • Viewing Visio Document Changes in Git
  • Visio ShapeSheet Functions D-F

Copyright © 2021 · Executive Pro on Genesis Framework · WordPress · Log in