Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I can create a vertical hierarchy chart in Visio from Excel data. Thing is, I need a horizontal (left to right) chart. Is it possible to create? If not, as a workaround, I rotated the chart, but now I should rotate each and every object in it as well.

I have used this tutorial.

I am using Windows 7, Office 2010, Visio 2010.

My other problem is that Visio messes up the hierarchy. Check this diagram out to understand:

enter image description here

This is the used excel data:

enter image description here

share|improve this question
    
Can you add an example of your data? Also excel and visio 2007 or 2010? What OS? –  Raystafarian Feb 7 '12 at 14:57
add comment

1 Answer

One option to consider are the Rotate Diagram commands: On the Home tab, look under Position > Orient Shapes > Rotate Diagram. There are several commands that change the layout of an existing org chart.

enter image description here

For example, if this is the original org chart.

enter image description here

Then using Rotate Left will transform it as shown below.

enter image description here

share|improve this answer
    
This could be a workaround, however, all the lines get messed up. I have to manually move all the lines and the boxes as well, which is not the way it should be. –  erdomester Feb 8 '12 at 7:57
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.