this post was submitted on 02 Aug 2023
5 points (85.7% liked)

Excel

179 readers
1 users here now

A community dedicated to any discussion about Excel. QnA, Discussion of other spreadsheet applications and ancillary programming/scripting are also welcome.

founded 2 years ago
MODERATORS
 

I’ve been making charts forever and whenever the data is negative, I move the x-axis labels to bottom-centre to get them out of the way of the bars. Suddenly, this isn’t working anymore.

I choose ‘bottom-centre’ or ‘middle’ and they just don’t move.

Any suggestions?

Attached is a Google pic of what it should be doing. Note the x-axis labels are at the bottom (A, B, C, D etc). I can’t move mine at all.

No, the options to move the labels aren’t greyed out. They’re selectable, they just do nothing.

EDIT: Fixed. It’s been moved to Labels > Labels Position. There must have been an update.

top 3 comments
sorted by: hot top controversial new old
[–] sherlockholmes 1 points 1 year ago

Unsure of the answer as I rarely make charts but is your canvas/chart box big enough for the changes you're selecting?

[–] Art3sian 1 points 1 year ago (1 children)

Yeah, I dragged it out to full screen. Plus, I’ve done this 1000 times before without worrying about dimensions. It’s almost as if Excel is bugging.

[–] sherlockholmes 1 points 1 year ago

Very strange.

Maybe try recreating a chart with dummy data in a new file to see if the problem is with the file or the underlying data?