Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .