Discussion Locked

Formatting series labels in Excel 2000

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.

This discussion is closed to new replies.