Change data in rows to columns in excel for mac

broken image
broken image

What if we decided to cluster these items by region? Domestic, Europe, Asia. We see the months across the bottom, so each cluster of columns is about a given month. Now, before I do that, notice that the data is clustered by months. Now, we don't see the word orientation in any of the menu items, but if I click the blue chart to the right of the data, this is a clustered column chart, on the chart design tab in the ribbon, there's an option to the right called switch row column.

broken image

In this worksheet called Year Data, we've got a number of charts and they are oriented a certain way.