One's going to be different than another. If it is a line chart, usually it's pretty obvious. I think you'll find over time as you try this button, you get some interesting results at times. Data doesn't really flow from state to state, but it certainly flows across time periods, so switch that one back. On this chart here, if I were to click there, go to the Design tab and Switch Row/Column, I think that makes almost no sense at all. Line charts in general should have a timeframe across the bottom: that's why we see the data here. When you switch line charts, usually it's pretty obvious that one of these choices is much better than the other. On the next sheet over called Line Chart, we see a chart that's already there. You'll get ideas sometimes about how data looks, how it doesn't look. Just Switch Row/Column on one or the other, and then decide which ones you're going to keep. For the moment, you'd have two charts identical. But what if it happens that you like both of these? You can easily create a chart and then simply press Control D to duplicate it. It's not to say that you're going to get a better choice all of the time in fact, maybe it's roughly 50/50.
No matter how that looks, consider the other options, Switch Row/Column. Based on the shape of the data that you selected to go into a chart, you're likely to get a different layout when you press Alt F1 or F11 to get a chart immediately. Instead of putting the months across the bottom, it puts the regions. Now, I'm going to highlight just half of that data, just this portion right here, and press Alt F1. I'm going to shorten that chart just a little bit, make it a little bit smaller.
I'm going to highlight some data here, say for the first six months. Something else happens at times, and you'll be a little bit mystified. The reason you want to do this, is sometimes you'll get ideas about different ways to display the data. How's that going to look? Maybe better, maybe not. I have a certain preference on this one, it's the previous chart, but nothing lost here by making a choice. As I click the button, Switch Row/Column, now we see the regions: Domestic, Europe and Asia. Notice how across the bottom, we see the months. I'm going to use it right now on the chart we see below. I strongly recommend using this button almost every time you create a chart. That doesn't mean a whole lot until you actually try it. The description doesn't quite do it justice. When you select a chart, on the Design tab is a choice called Switch Row/Column.
0 kommentar(er)
