98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Visio Training and help » Visio organisation charts
Visio organisation charts
Resolved · Medium Priority · Version 2010
Lisa has attended:
Visio Introduction course
Visio Advanced course
Visio organisation charts
Hi,
I have recently been on both Introduction and Advanced courses for Visio.
Ive now created an organisation chart for my company. After creating the chart, I can update the "shape data" (Ive used the odbc data option in the wizard) but I cant seem to update the chart itself so that new people (excel rows) are added in.
This is really starting to frustrate me so any help on this would be really appreciated!
Thanks.
RE: Visio organisation charts
Hi Lisa,
Thank you for your question.
Is the data you are linking to in Excel format? When you go through the Organisation Chart Wizard, do you choose Excel as the option or ODBC and then connect to Excel that way?
If the data is in Excel, has the data got defined column headings? If so, you can format the data using the Table formatting feature which makes the data dynamic i.e. If you add more rows the data range will automatically expand.
To apply Table formatting, click in any cell below the headings, go to the home tab, stlyes group and choose an option from the Format As Table option. Make sure the first row selected is the row with the headings and tick the 'Header row' checkbox.
I am assuming the range is not updating automatically as you add new rows to the bottom.
Regards
Simon
RE: Visio organisation charts
Hi Simon,
Yes, the data Im using is Excel based. I have tried both options. I found the ODBC easier for updating (Shape info only, not addition of shapes) as I could right click and update.
I will try this out and let you know how I get on.
Thanks!
RE: Visio organisation charts
Hi Lisa,
How are you?
I was just wondering how you got on with trying the options suggested.
If you have resolved the problem, then could you please mark the question as resolved.
Looking forward to hearing from you.
Regards
Simon
RE: Visio organisation charts
Hi Simon,
I havent had a chance yet to be honest. Im hoping to have a look this next Monday. Will let you know asap.
Thanks.
Kind regards,
Lisa
RE: Visio organisation charts
Hi Simon,
I have converted the data to a table (its a bit difficult as I have to use Vision 2010 with Excel 2003). I have converted it to a "List" using the List toolbar.
I have selected ODBC again but it still wont update any new records I add. Am I doing something wrong?
If you can call me sometime today on [number removed for privacy] I would be very grateful.
Thanks,
RE: Visio organisation charts
Hi Lisa,
Thank you for the update.
Unfortunately I will not be able to phone you as I am working non stop this week onsite and at our training centres in central london.
The forum is an email forum as it is difficult to monitor questions and responses by phone.
I will look at some forums and see if I can propose any new solutions.
Regards
Simon
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Thu 20 Dec 2012: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Visio tip:Creating an organisation chart in Visio using Excel dataA quick and easy way to create an organisation chart by importing names and titles stored in list format in an Excel spreadsheet into Visio. |