From the course: Excel: Introduction to Charts and Graphs
Join today to access over 24,700 courses taught by industry experts.
Change the orientation of a chart
From the course: Excel: Introduction to Charts and Graphs
Change the orientation of a chart
- [Narrator] When you select a chart or you've just created a chart, on the Chart Design tab, among the many buttons you'll see, off to the right is a button that first might not get your attention. Switch Row Column and the description, swap the data over the axis, may not mean much to you, but it's a button I use nearly every time I create a chart. I have selected the green chart on this worksheet, just to the right of the data. As I click it, the colors that we are now seeing that represent different regions, domestic, Europe and Asia change, and now each color refers to a different month. If we click that button again, we call it a toggle switch, we go back and forth. Sometimes the chart that you see here, quite a bit different than a previous example, is more valuable. I'm not saying that's always the case, but it's not uncommon when you see the data this way. You either gain additional insight into the data itself, or you might be saying, well, let's have both charts. And…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.