Discussion Locked
0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a user who has a beautiful spreadsheet whose x-axis labels in Excel are not formatting nicely. These are not data labels so I can't just select them and click on the left-justify or right-justify buttons. The chart is pulling the x-axis titles/labels from another worksheet where they're formatted as left-justified which is what the user wants but in the chart, they're center-justified which makes the whole chart look sloppy. I've tried double-clicking on the labels, I've tried changing the formatting on the original worksheet...I can't seem to find anything that lets me change the justification of those labels...help.
5 replies
by sparent
The only thing I can think of trying (I don't have Excel on the machine I'm currently using) is to have copies of the labels in your current worksheet. Use links if need be to have the cells populated automatically. I think the problem is that Exceldoesn't see the formatting on the other worksheet.
Apply the desire formatting on the in-sheet labels.
by jgsearls
I hate to rate a question as unacceptable because it sounded like a really good idea to me but I just tried that and it still left everything as center-justified. Maybe when you get to a computer with Excel, you can take a look at this for me....thanks
by dmambo
Once the data labels are enabled, you should be able to point the curser on one of the labels and right click. Be sure you see the "(Title) Data Labels" screen tip. This should hilite all the data labels and display a menu choice of "Format DataLabels". Click that choice and change the alignment. You can also edit the individual data labels by double-clicking them.
by jgsearls
Also didn't work. Thanks, though.
by jgsearls
This question was closed by the author
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
Discussion
Useful software Tip or Shortcut
0 helpful
1 reply
Question Unanswered
Best Low-Latency VPN Protocols for Competitive Mobile and Online Gaming
0 helpful
0 replies
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies