lahaeyes.blogg.se

To straighten out the labels, I need to restructure the data.

Well, if I visit Select Data, I can click Edit under Category Axis Labels, and then expand the range to include region.Īs you can see, this adds a level to the axis labels, though it's not very legible at the moment. Holding down the control key, it's a simple matter to plot activity by city in a column or bar chart.īut what if I want to group the cities in by region? We have columns for region, city, airport code, and activity, which represents total take offs and landings. Here we have a list of the busiest US airports. This is easy to do as long as you structure the source data in a particular way. In some cases, you may want to create a chart that shows more than one level of axis labels. In this video, we'll look at how to build a chart with multi-level axis labels.