Two-level axis labels in Excel can be a great way to add extra information to your charts and make them more informative. Here's how to create them:
First, select the data that you want to include in your chart. In this example, we'll use data from cells A1:B5.
Next, click the Insert tab on the ribbon and then click the Column chart button. A column chart will be inserted into your worksheet.
Now, right-click on one of the columns in your chart and select Format Data Series from the menu that appears.
In the Format Data Series dialog box that appears, select the Axis Options tab.
Under the Axis Options tab, check the box next to Secondary Axis and then click OK.
Your chart will now have two y-axes. The left y-axis will be based on the data in column A and the right y-axis will be based on the data in column B.
To add axis labels, click on the chart and then click the Chart Elements button. A list of chart elements will appear. Check the box next to Axis Titles and then click on Primary Horizontal Axis Title or Primary Vertical Axis Title depending on where you want your axis labels to appear.
A text box will appear. Type in the text that you want to use for your axis label and then press Enter. Repeat this step for the other axis label.
And that's it! You now know how to create two-level axis labels in Excel.
Get started with Causal today. Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.