![]() ![]() Next, I'll remove the extra, unneeded entries from the region column. First, I'll sort by region and then by activity. 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.
0 Comments
Leave a Reply. |