Wonderful Two Level Axis Labels Excel
Select the secondory axis on top.
Two level axis labels excel. For a dual set of labels it requires two dummy series and some cleverly laid out text labels. Select the first column product column except for header row. Its important to know that this checkbox only appears when the axis labels range includes another set of values.
Go to DATA tab in the Excel Ribbon and click Sort A to Z command under Sort Filter group. Go to LayoutAxes and plot the secondary axis on top. So I want to.
Select Design Change Chart Type. First off you have to click the chart and click the plus icon on the upper-right side. Grouped by aircraft type.
And you can wrap other labels. Just do the following steps. Select Secondary Axis for the data series you want to show.
This will save your title. It is the number of aircraft per month. Add the total number of aircraft per month as an additional group Plot.
Two-level axis labels are created automatically by Excel. By default Excel creates a chart with the primary horizontal axis at the bottom and with the primary vertical axis at the left side of the plot area shown as orange in this example. Two-level axis labels are created automatically by Excel.