Horizontal hierarchy chart in Visio from Excel

Question

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:

This is the used excel data:

Answer 1

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.

For example, if this is the original org chart.

Then using Rotate Left will transform it as shown below.