Switching rows and columns for a different view of the data


show more Switching rows and columns for a different view of the data provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth show less
please wait ...

Switching rows and columns for a different view of the data

Of all the many buttons available to you on the Design tab once you've selected a chart is a not-so-obvious button, third from the left, called Switch Row/Column. This has to do with what we call the orientation of the chart. The chart that's highlighted, the one roughly across columns H through N here, is based on the data that we see over in columns A, B, C, and D. And nothing wrong with the chart, really. It lacks a few items of explanatory information, and it's a typical-looking chart that we see when we highlight data and, whether we create a quickly or from the menu, a column chart.

Now what does Switch Row/Column do? Let's click it, and you'll see what happens. The data is oriented quite a bit differently in this example here. Let me switch it again. You can go back and forth; it's a toggle switch. The initial display shows each cluster of columns in this group representing a different month, and of course we're talking about Domestic, Europe, and Asia for...

Switching rows and columns for a different view of the data
Video duration: 3m 9s 3h 36m Intermediate

Viewers:

Switching rows and columns for a different view of the data provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...