visio database and graphics driven by excel spreadsheet

[william.f.jones]

Hello,

I am attempting to start with a set of 624 XY pairs (two columns of real
numbers) in an Excel spreadsheet and get these plotted in Visio as a set of
points in a simple linear XY space. One example application of this is to
form a near circle
in which the precise location of the points is critical. The analysis of the
location
of these points by visio graphical methods is useful.

The help info says NO PROBLEM for driving shapes from an Excel spreasheet.
My copy of Visio 2003 Bible also says NO PROBLEM.

Yet I have having very little luck.

I seem to be able to get the PinX and PinY position for a single visio
graphical stencil "Data Point" to work. By this I mean that I can link
(export) even multiple data point to a database in an Excel spreadsheet.
Then I can manual edit the Excel file and then the "Database Refresh"
seems to actually change the PinX and PinY location - but only for one
of the several Point shapes.

The problem is that I am unable to do this for multiple Data Point shapes.

Any suggestions?

Thanks,

Bill

 

[Mark Nelson [MS]]

This article and subsequent posts walks through the process for Visio 2007.
Some of the data connectivity and refresh information is specific to Visio
2007, but the basic shape design will work in Visio 2003.

http://blogs.msdn.com/visio/archive/2007/02/06/introducing-the-bubble-chart.aspx

--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

"(e-mail address removed)"