• 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
    • Visio Shape Report Converter
    • 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
    • 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
      • 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
    • 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 / Creating Linked Timelines From Project

Published on March 9, 2010 by David Parker

Creating Linked Timelines From Project

A recent newsgroup question asked if it is possible to create shapes in Visio 2007 that are linked to tasks in a timeline in Project …. without lots of coding!  Well, that sounds like a challenge that I can’t resist, so here goes!

First, I am using Microsoft Project 2007 and I have loaded the Commercial Construction sample project that is in the Visio SDK.

image

The first part of the process is to export the project to a suitable format that can be used as a data source in Visio 2007 Pro.  I chose to Save As a Microsoft Excel Pivot Table, and selected the Tasks type of data.  I then chose to Base on Table … Rollup Table:

image When the export has finished, you will get a workbook with two worksheets.  The second one contains a pivot table…

image … but the first one contains a table that we can use as a data source in Visio:

image Next, I started a new blank document in Visio, and changed the Page Setup to be:

  • Print Setup / Printer paper = Landscape
  • Drawing Scale / Pre-defined scale = Metric / 1 : 2.5
  • Page Properties / Measurement units = Days

I then selected Data / Link Data to Shapes, and selected the Excel Workbook that I just created, and chose Task_Table1$ as the range.  I selected Next, accepting the default for the Columns and Rows, but I added Resource_Names to the Unique Identifier, as well as the ID …

image

After selecting Finish on the Data Selector, I dragged the first record onto the empty page, and dropped it.

image 

I ensured that I had Developer Mode ticked in Tools / Options / Advanced.  Then I defined a new Shape Data row, called EarliestDate, for the page.  This needs to be set as a Date Type row.

image I then entered the date that is one day less than that in my project.

image I then resized the rectangle and edited its Data Graphic to display a few of the fields, and I used the Resource_Names as Color By Value.

image

I then opened the ShapeSheet of the rectangle, and amended the following cell formulas:

  • LocPinX = 0
  • PinX=GUARD((Prop._VisDM_Start_Date-ThePage!Prop.EarliestDate)*(ThePage!PageScale/ThePage!DrawingScale))

image

I then altered the X fomulas in the second and third rows of the Geomtery1 section with the following:

=GUARD((Prop._VisDM_Finish_Date-Prop._VisDM_Start_Date)*(ThePage!PageScale/ThePage!DrawingScale))

This has the effect of altering the width of the coloured rectangle, without changing the width of the shape.  This is important because the width of the Visio 2007 Data Graphic is linked to the width of the shape …. something that has been fixed in Visio 2010.

I then opened the Shapes Document Stencil so that I could drag the Data Linked rectangle onto it.

imageI then renamed this Master as Resource Task, and ticked Match master name on drop.

I then deleted the existing Rectangle master … it is no longer needed.

I could then select the new Master, and drag and drop rows from the External Data window onto the page, knowing that the horizontal position is linked to the start date, and the width of the coloured rectangle is linked to the duration.

image Okay, I played with the scale and width of the master a little, until I was happy, and I have not yet created a header shape for the timeline, but I think this blog answered the original question…

Related

Filed Under: Visio

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

  • Update to LayerManager add-in for non-English users
  • Pushing Data Visualizer in Visio beyond its limits
  • Pushing Data Visualizer in Visio to the limits!
  • Teams Tuesday Podcast Recording about Visio
  • Linking Data to Visio Shapes in Code

Categories

Tags

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

  • Update to LayerManager add-in for non-English users
  • Pushing Data Visualizer in Visio beyond its limits
  • Pushing Data Visualizer in Visio to the limits!
  • Teams Tuesday Podcast Recording about Visio
  • Linking Data to Visio Shapes in Code

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