Dave Kong
asked on
Excel 2016: Need to Left-Align Y Axis of Gantt Chart
I am creating a Gantt chart in Excel 2016. It is working great, but the Y-axis labels are right aligned. I need to make them left aligned but not finding a way to do that. I saw a note online about accessing the chart properties and turning off the "truncate label" command, but I am not finding a way to access the properties. I either need to know how to access the properties or find another way to left align the Y axis.
ASKER
Sure. Here is a portion of the larger Gantt chart I have been working on. You can see how the Y-axis labels are right aligned.
Sample-Gantt-for-Experts-Exchange.xlsx
Sample-Gantt-for-Experts-Exchange.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Syed:
That is fantastic! Bravo! I am holding on to this sample.
Thank you!
That is fantastic! Bravo! I am holding on to this sample.
Thank you!
ASKER
If I can quote Boogie Nights: "genius... genius!".
Dave
Dave
Do you want to close the question or is there something else needed?
ASKER
You can close the question. Thank you very, very much!
I cannot close the quiestion; you will have to do it.
You should select "This is the solution" under the solution I provided and complete the process.
You should select "This is the solution" under the solution I provided and complete the process.
Can you post a sample excel file for experimenting?