RE: Linking Visio Orcharts to Excel data

Tech-Archive recommends: Fix windows errors by optimizing your registry

Ahhhh, so this is not a common thing to try? I couldn't find any specific
reference on this site as you suggested, but I get lost in technical mazes
pretty quickly! It's frustrating, because I'm pretty sure it is do-able, tho
maybe only in Visio Pro, as I mentioned earlier.

I'll look at Parker's book, thanks for the ref
--
Compleat Amateur


"WapperDude" wrote:

My apologies! I misunderstood. I believe this may have been talked about is
some previous posts. Try searching using some combination of org, excel,
etc. I've not tried to do what you're after, but it strikes me that you may
have to write some VBA code. You might want to check out David Parker's
book, "Visualizing Information with Microsoft Office Visio 2007". Search for
his name, and you'll get a link.

Hope this helps.
Wapperdude


"Compleat Amateur" wrote:

Hiya WapperDude, thanks for the post.

I'm not sure we are on the same wavelength yet ..... creating static Visio
orgcharts from Excel data (and vice versa) is dead easy, done it quite a few
times.

What I want to do, having done this, is create permanent links between the
Excel HR data file and the Visio orgchart, so changes in either can be
reflected in the other. I don't think that's what you are referreing to,
forgive me if I'm wrong.
--
Compleat Amateur


"WapperDude" wrote:

Yes, it can be done in Visio standard. Easy way is to start an org chart
drawing. Then there will be an Organization Chart entry on the toolbar.
Select the import organization data. That will start a wizard which should
get you thru the process.

From the Visio help, there's a demo: "Create your organization chart by
using the Organization Chart Wizard"

You might also search this site and the general questions for additional
info on the org chart wizard.

Hope this helps.
Wapperdude


"Compleat Amateur" wrote:

Good morning

I'm trying to create dynamic links between an Excel org data source and
Visio orgchart in Visio 2007 Standard.

Visio 2007 Inside Out doesn't say so, but I think this can only be done in
Visio Professional, not Visio Standard.

Alternatively, how to create the links?
--
Compleat Amateur
.

Relevant Pages

  • Re: visio and excel
    ... Visio will actually generate an Excel file that you can fill in and import ... Run the Organization Chart wizard and choose ... the "Information that I enter using the wizard" option. ... Note that Visio does not support refreshing an existing Organization Chart ...
    (microsoft.public.visio)
  • RE: Linking Visio Orcharts to Excel data
    ... Try searching using some combination of org, excel, ... "Visualizing Information with Microsoft Office Visio 2007". ... Then there will be an Organization Chart entry on the toolbar. ...
    (microsoft.public.visio)
  • Re: visio and excel
    ... \par When I try to add a row for new employees to an Excel file created by Visio ... Run the Organization Chart wizard and choose ...
    (microsoft.public.visio)
  • RE: Linking Visio Orcharts to Excel data
    ... I found a reference in the Visio General Users Forum: RE: Linking Visio ... Orcharts to Excel data. ... "Compleat Amateur" wrote: ...
    (microsoft.public.visio)
  • Re: visio and excel
    ... When I try to add a row for new employees to an Excel file created by Visio ... Run the Organization Chart wizard and choose ...
    (microsoft.public.visio)