Hi,
In the left graph, X axis labels are aligned to the bottom.
In the right graph, they are not.
Is there any way to fix it?
Both X axis labels came from the same data (Screenshot 3).
Hosun
Screenshot 1
Screenshot 2
Screenshot 3
I believe it is the "year" data in your table that is the problem.
In your charts, all of the odd numbers align with each other and all of the even ones align with each other but odds do not align with evens. The left chart is all evens so they all align. The right one is a mix so they do not all align. Something is different about the X axis label data for the odd years vs even years.
In your table, the "year" data is aligned to the left of the cell which indicates it is text, not actual numbers. My guess is all of the odd years have an extraneous space or two after the numbers. They are five or more characters in length vs four. Select the column of years and format it to be numbers. That will remove the extraneous spaces and turn the "years" into actual numbers. If you need them to be text, format them back to text.
I believe it is the "year" data in your table that is the problem.
In your charts, all of the odd numbers align with each other and all of the even ones align with each other but odds do not align with evens. The left chart is all evens so they all align. The right one is a mix so they do not all align. Something is different about the X axis label data for the odd years vs even years.
In your table, the "year" data is aligned to the left of the cell which indicates it is text, not actual numbers. My guess is all of the odd years have an extraneous space or two after the numbers. They are five or more characters in length vs four. Select the column of years and format it to be numbers. That will remove the extraneous spaces and turn the "years" into actual numbers. If you need them to be text, format them back to text.
Thank you very much!
Hosun
alignment of axis labels
