Excel - 2-D Bar Chart - Change horizontal axis labels

Solution 1:

I think you need to create a helper X-Y scatter line.

Please add the 3 columns, X-value, Y-value and X-Axis as following.

Then you could select data of X-value and Y-value, create a X-Y scatter line.

Right-click the chart > Chart Design tab > Select data add other two series, Start and End.

And then go to Chart Design tab > Change Chart Type > All Charts tab > Combo, set different chart types as below.

Slect the chart, locate to Chart Design > Add Chart Element > Axes > Choose all Horizontal and Vertical axes to show.

Please choose the Secondary Horizontal, set it across 0.

Choose the Secondary Vertical, set it across 0 too.

If needed you may also choose Primary Vertical, then set its values in reverse order.

Juest keep the Secondary Horizontal, add lable for X-Y scatter line. Choose one lable, enter "=" in Formula Bar, click C14 (the lable you need, on my sample, the lables are not right), press Enter.