

Repeat this step for the other axis label.Īnd that's it! You now know how to create two-level axis labels in Excel. Type in the text that you want to use for your axis label and then press Enter. 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. To add axis labels, click on the chart and then click the Chart Elements button.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. Under the Axis Options tab, check the box next to Secondary Axis and then click OK.In the Format Data Series dialog box that appears, select the Axis Options tab.

Now, right-click on one of the columns in your chart and select Format Data Series from the menu that appears.Select X Value with the 0 Values and click OK. A column chart will be inserted into your worksheet. Right click Graph Select Change Chart Type 3. Create a Pandas Excel writer using XlsxWriter as the engine. Next, click the Insert tab on the ribbon and then click the Column chart button. This program is an example of creating a column chart with axis labels.In this example, we'll use data from cells A1:B5. First, select the data that you want to include in your chart.Two-level axis labels in Excel can be a great way to add extra information to your charts and make them more informative.
