Left Align Vertical Axis

This type of graph (bar) is quite special, because it has opposite to all other graphs in excel assignment of axes.
I doubt if such alignment as you want could be obtained with standard tools.

Two main options come to my mind:
See Andy's suggestion on using texboxes for special labelling: http://www.andypope.info/vba/Axislabel_textboxes.htm
Use Camera tool (more about this tool - see for instance https://trumpexcel.com/excel-camera-tool/ ) presented in attached file

Did you mean right align? Your picture looks like the labels are centered.

See attached which has right aligned category labels.

The chart is a mixture of stacked bars for Planned dates.
Lines for actual dates, which also provides a proper date horizontal axis

1321576.png

Not sure if your version of excel offers the ability to remove word wrap from data labels.
But in latest version you can use data labels to mimic vertical axis category labels with left alignment.

To position the data labels you can use this line of code in the immediate window. ALT+F11 to go to VBE. CTRL+G to open immediate window.

Apply datalabels to Target Pad series. Format data label to show Category and on the textbox formatting remove wordwrap.
Select chart and use the following line of code in immediate window

Please Login or Register  to view this content.