How to change the horizontal axis and legend in a bar chart?

[IvyAurora]

Good day everyone!

I have been puzzeling for hours on how to change the horizontal axis on my bar chart. Currently it is automatically labelling them with 1,2,3,4,5. However, I need them to be labeled (i) (ii) (iii) (iv) (v) AND then I need the legend to also show (i), (ii), etc... I've already tried it with Format Axis and with changing the descriptions under Select Data... However, under format axis it changes all the labels to the same name and under select data I get the same issue. Can somebody help me?

Kind regards,
Ivy

[jeffreybrown]

It always beneficial when posting a question to also post a worksheet so we don't have to recreate any data.

Anyway, the legend is for the data itself, not the horizontal axis. That is in my understanding.

As far as the horizontal axis, you can control that thru the spearsheet. Not thru a format like you seems to be trying.

The horizontal axis is automatically using 1, 2, 3, 4, etc. because you are not controlling it. The data is. It's just creating an ordinal numbering system.

[IvyAurora]

This is great! Thank you, next time I will add a spreadsheet (this is my first question ever)

[jeffreybrown]

No problem. Glad it helped and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.