Axis legends in charts

Hi.
I haven’t find a way to automatically set the legend for chart axes, based upon category or item names, for example. That would be convenient for 2D scatter plots
I opted for inserting a text box manually as axis legend, but did not manage to create a label with a vertical orientation for the y-axis.
Is there some feature I am missing?