Build an organisation chart using visio 2007

Is your business going through a re-organisation?  Maybe there is a new team, or an old team has suddenly disappeared?  If so, it is time to update your organization chart!

So how do you create an organisation chart using Visio 2007?

1) Click on the “File” menu

2) Move your mouse over “New”, then

3) Move your mouse over “Business”, then

4) Click on “Organization Chart Wizard” (click on either Metric or US Imperial depending on where in the world you live

This starts the Visio 2007 Organization Chart Wizard.  There are a few steps to go through before you will have a compete org chart though – lets take a look!

1) If this is the first org chart you have created in Visio – make sure you select “Information that I enter using the wizard” and click “Next”

2) If you have Excel, select “Excel” and then put in the file name for where you want to store the data behind your org chart.  Click on Browse to find the folder you want to save the file in, type in the file name you want

3) Click “Next”

4) Excel will open up a workbook with some dummy data.  Using the format in the workbook, enter the data for your org chart

5) Save the excel workbook when you are done, and then close Excel.

6) On the next page of the Organization Chart Wizard, select how you would like the org chart to be formatted if you have too many people to fit on one page.  The easiest option to start with is simply let the wizard to automatically break it across pages.  Make sure that option is selected, and click “Finish”

There you have it – your brand new org chart!  The best part is that now that it is built of data stored in excel, all you need to do is update your spreadsheet, re-run the Visio 2007 Org Chart Wizard, and you will have a very fresh version of your organization chart.

‘till next time!

Add-ins and Articles for Visio 2007 – Microsoft Visio Toolbox

For all those Visio lovers out there, then you should already know about the Microsoft Visio Toolbox.  If not, you seriously can’t call yourself a Visio lover!

The Visio Toolbox is a collection of articles, case studies, and most importantly add-ins for Visio 2007.

So if you are looking for justification for your boss to upgrade to Visio 2007, articles on interesting topics such as “Silverlight and Visio”, or add-ins such as the Rack Server Virtualization Add-In, the Disk Space Monitoring Add-in, or the Microsoft Exchange Server 2007 Visio Add-in… then you need to check out the Microsoft Visio Toolbox!

‘till next time!

Office 2007 Forum – get your Office 2007 question answered!

They have been closed for a while now, but today I am re-launching The New Paperclip’s Office 2007 Forums!

What does that mean?  If you have any question at all about Office 2007, whether it is Word, Excel, PowerPoint, Outlook, Access or even SharePoint Designer… you now have a place where you can look for answers.

I will be there frequently, and we will be able to draw on the collective knowledge of the community to get your question answered!

Here are the links to each of the forums:



So there you have it – the quick and easy way to get your Office 2007 question answered!  See you on the forums!

‘till next time!

Get Office 2007 Help, Tips, Tricks, and Tutorials on Twitter!

Are you a member of the Twitterverse?  If you use the micro-blogging service called Twitter, you can how get your favorite productivity articles on Word, Outlook, Excel, PowerPoint… in fact the entire Microsoft Office 2007 suite directly in your Twitter feed.

All you have to do is follow @TheNewPaperclip.

I will be on there regularly so if you have any questions or suggestions for articles you can post them to Twitter as well!

‘till next time!

Subscribe to the Office 2007 Help, Tips, Tricks and Tutorials Newsletter

Did you know that you can get a regular email jam packed with Office 2007 tips direct from!

All you need to do is register using this form

Register today and you will receive a free copy of my e-book “Your 10 minute guide to getting up to speed with Microsoft Office 2007”

’till next time!

Office DevCon 2008 – Sydney, Australia

Are you an Office freak from down-under?

On the weekend of the 15th and 16th of November, a group of Aussie Office fanatics are putting together a conference called Office DevCon2008.  From what is on the agenda it looks like a great event for anyone involved in managing Office products in their workplace, or for those interested in getting a little more intimate with the Office 2007 suite, SharePoint and more.

Registration is free… and there might be sneak previews of Office 14 as well!

If you are in Sydney in mid November, make sure you check it out.  You never know, you might bump into yours truly there as well 🙂

You can find out more by visiting the Office DevCon 2008 website

’till next time!

Reduce your carbon footprint with Microsoft Office 2007

Want to be a desktop publishing great, spreadsheeting wiz or PowerPoint guru and help the environment at the same time?

Guess what – you might be already!

Microsoft have released an extra section on Microsoft Office Online called Lighten up: Reduce your carbon footprint and workplace costs.

Obviously they left one tip for reducing your impact on the environment… instead of investing in all those Office 2007 self help books, why not just bookmark your favourite Office 2007 help, tips, tricks and tutorial site!


’till next time!



Technorati Tags: ,

I have a friend on the inside…

Want to know lots of in depth techincal stuff about Microsoft Office?  Well if I can’t answer it, there are plenty of people at Microsoft who know their stuff!

One of them is Alistair Speirs, a Office Technology Specialst at Microsoft Australia.  If you want to dive deep into everything office (beyond the tutorials from yours truely!) then you should check out his blog…

Check out some of his posts on Business Desktop Deployment, Enterprise Search, Office Busines Applications, OpenXML, and one he stole from me… Random text in Word 🙂

TNP and Alistair go way back… he knows his stuff!

’till next time!

Deploying Office 2007 in the Enterprise

A lot of organisations have had a chance to play around with Office 2007 for a while now, and are now walking down the road of deployment.  But where to start?  Deployment has changed a little from previous versions of Microsoft Office, so it might be a good idea to brush up on a few things before kicking off that Office 2007 deployment project.

First step is to visit the 2007 Microsoft Office System Plan and Deploy with Confidence site.  This site includes Webcasts (from level 100 through to 400), Virtual Labs, and Podcasts to help you get you complete your deployment successfully.

Secondly, check out some of the articles on deployment from media outlets such as Computerworld.  These start to give you a real world perspective on the types of issues you might face during your deployment.

Thirdly, if you are ready to go now, check out articles from experts in the community, just like Aaron Parker’s post on Deploying Office 2007 with Group Policy Startup Scripts.

Finally, once your deployment is complete, make sure you let everyone in your organisation know about – so they can get up to speed quickly with the new features of Office 2007!  Remember… the key to a successful deployment is not the deployment itself, but the training and adoption that takes place afterwards.

’till next time,

Download the 2007 Office Resource Kit

Are you a systems administrator charged with deploying and maintaining an Office 2007 environment? You can now download some key sections for the 2007 Office Resource Kit.

There are four different titles available, Planning and architecture for the 2007 Office release, Deployment for the 2007 Office release, Security for the 2007 Office release, and Technical reference for the 2007 Office Release

You can download each of them from the Microsoft Office System site on Technet