x-axis disappears when "show data in hidden column" unchecked

Question

Hi, so I have this chart in Excel for Mac v16.57 running on macOS v11.4

with these data selections - all 5 series plus the horizontal axis labels are selecting columns Q to BX

When I uncheck "show data in hidden columns", the x-axis disappears

I'm thinking the x-axis is actually showing at y-axis value of -10% just like in the first chart but in this situation that would be "off the chart" and therefore not showing. Is there actually a way to get it to show? Is this a bug in the mac version?

Thanks a lot

Btw, the x-axis settings

Answer 1

Thank you, Tin. I did update office v16.58 but that was not it.

The problem as it turned out was my x-axis values were themselves in a hidden row!

It's all good now thanks for your help

Answer 2

Hi rock hammer:

Based on my test, Office version 16.58, I cannot reproduce this issue.

Please make sure your copy of Office will always be up to date with the latest version. You can reference this article：Update Office for Mac automatically - Office Support (microsoft.com).

If the problem persists, please try running Office by starting up your Mac in safe modeto see the result. This can help us check whether issues you are experiencing are caused by software that loads as your Mac starts up.

We appreciate your understanding that sometimes the initial suggestions may not resolve the problem very soon. However, we can work together to narrow down and resolve the situation. So, Please kindly provide more information below to let us work further:

• Does the same issue still occur if you create a new workbook？

Hope this will help you.

Tin