CODEWITHSUNDEEP
charts
Yax
Yax

Reputation: 11

How to make chart with two data axis in different sytle

How to apply different styles on characters X1 (bold and center/left position) and show asdasd (rightposition) in Y-axis of a table??

reality Fig 1

edit in paint :) Fig 2

Upvotes: 1

Views: 28

Answers (1)

teylyn
teylyn

Reputation: 35915

You can use a multi-level axis for the category axis.

enter image description here

If Excel does not recognize the multi-levels, then you can fix that in the data source dialog.

enter image description here

There is, however, no way to format the axis labels to have different fonts and font sizes for the different levels. Excel simply does not support that.

Edit: there is also no setting to turn the outer level label around. Excel will determine how to show it and there is nothing the user can do to change that.

Don't shoot the messenger.

Upvotes: 1

Related Questions