Vision Org Chart synchronised to Excel

VISIO

    Sponsored Links

    Next

  • 1. How do I curve the lines of the "perspective" in a raised block i.
    I am trying to create a cube in Visio with a rounded line. However, when I change the line of the block itself the "perspective" remains the same. I would like the "perspective" to also have rounded edges that match the block itself.
  • 2. How can I hide the date displayed in the associated text box for .
    I am using Pin Milestones to link events to points on the timeline. Showing the actual date abover the text describing the event is not really necessary as the pin links to the date in the timeline. Moreover the date entry takes up a whole line space above the event text. As I am pushed for space on the timeline I would welcome techniques for hiding the date displayed.
  • 3. Save visio as WMF, insert in word, paste to outlook problem
    I'm using Outlook Web Access. The application requires that I cut and paste from a Word document into Outlook Mail - usually as a reply to incoming mail. I have created some diagrams (in Visio), saved them in .WMF format, and inserted them into the Word document, and all looks well and prints well. When I highlight the appropriate section in the Word document and copy/paste it into the mail, all the lines disappear! - text is intact. Diagrams are meaningless! Am I doing something wrong, or is there a better way? I have used some attachments, but many corporate email systems reject or strip attachments, so an "in context" solution is preferred. Thanks for your help and suggestions.
  • 4. Is there a way to add a connection point to a shape in Visio?
    I am trying to add connection points to a basic shape in a Data Flow Diagram (four just doesn't seem to be enough off a process) but can't figure out how to do it. Does anyone know?
  • 5. is there a way to crop a corner out of a rectangular image in Visi
    Using subtract on two shapes accomplishes what i want to do, but when the first shape is a .gif image, it does not work.

Vision Org Chart synchronised to Excel

Postby Cathy » Fri, 30 Nov 2007 17:10:15 GMT

I have also been trying to find a way to link an ORG chart to Excel. i.e. 
When I import data into an Org chart from an excel Spreadsheet. I then want 
to link the Org chart to the spreadsheet so that any changes made in the Org 
chart is automatically updated in the spreadsheet.

Regards
C 



RE: Vision Org Chart synchronised to Excel

Postby QWwgRWRsdW5k » Fri, 30 Nov 2007 23:41:00 GMT

Unfortunately the orgchart wizard is a one-way street.
al






Re: Vision Org Chart synchronised to Excel

Postby Cathy » Sat, 01 Dec 2007 05:11:32 GMT

> Unfortunately the orgchart wizard is a one-way street.

Thank you for the response. I was looking under Add-ons -> Visio Extras -> 
Link to Database and found Excel in here as an option. But I can not seem to 
figure out how to get it to do this.

If it is only a one way street, can I link it so that any changes made in 
the Excel Sheet is immediately reflected in the Diagram when it is next 
opened?

Regards
C
Visio 2003 Professional 



Re: Vision Org Chart synchronised to Excel

Postby QWwgRWRsdW5k » Sat, 01 Dec 2007 05:31:04 GMT

I haven't played with the wizard in awhile but some of the issues that used 
to be out there include:

The orgchart wizard (as a performance thing) does a complete redraw whenever 
the data is loaded, consequently if you have modifed anything the refresh 
overwrites what you have customized.

The (re)creation based on excel changes would require that somebody write 
the code for excel to a.) recognize the change and b.) start visio and then 
tell it to recreate the drawing. That becomes and excel coding project.







Similar Threads:

1.Org charts - displaying different fields on synchronised pages

I know it sounds a little contradictory but....
I've created some linked (synchronised) pages for the org structure in my 
branch of of our organisation.
On the top level (ie page 1) I'm just looking to display each Director's 
name and the name of their team 
On the synchronised pages (ie pages 2-5) for each of those teams I want to 
show team member's names, their roles and their phone numbers (maybe a 
picture).

However, when I change the display field options under the Org Structure 
menu it makes the changes globally.

Is there any way to show the different fields on different pages?
thanks
Jon

2.synchronised pages in org structure drawing

I've created some linked (synchronised) pages for the org structure in my 
branch of of our organisation.
On the top level (ie page 1) I'm looking to display only the Director's 
name and the name of their team 
On the synchronised pages (ie pages 2-5) for each of those teams I want to 
show team member's names, their roles and their phone numbers (maybe a 
picture).

However, when I change the display field options under the Org Structure 
menu it makes the changes globally.

Is there any way to show different groups of fields on the different pages?
thanks
Jono

3.displaying extra fields in org chart after running org chart wiZard

hi iread these instructions in the meaasge board:

"After you run the wizard, expand the "Organization Chart" 
menu and click
Options...
Then click on the "Set Display Fields..." button and add 
the fields you want
displayed in the shapes.


Can you do this in visio 2000, i am having trouble
.


4.Order changed after import data from excel to prepare org.chart

I found that a list of excel data after importing to Visio for producing org,chart.  The order is messed.  I need to spent much time to reorder it ? Why does this happened ?  As I need to import several hundred of data, it spent me much much time.  Any one can help me? 

5.refreshing data from excel in org chart

Once I've used the org chart wizard to construct an org chart, can I update 
the chart if the excel sheet is changed? At the moment it looks to me as 
though I have to go through the wizard again.

On a similar topic, what is the logic used when laying out the subordinate 
boxes? On my test excel sheet I named staff 'person 1', 'person 2' etc up to 
6 and they were layed out in the order 5 3 1 6 2 4. That's pretty annoying 
because it means I can't place my boxes in a chosen order e.g. alpabetically 
or by seniority etc. Is there a way around this? 


6. Alphabetize Org. Chart when using excel database

7. Link Excel Spreadsheet to Visio Org Chart...how?

8. Excel file into Visio Org Chart wizard formatting



Return to VISIO

 

Who is online

Users browsing this forum: No registered users and 90 guest