Avatar of Dave Kong
Dave Kong
Flag for United States of America 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.
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Saqib Husain

8/22/2022 - Mon
Saqib Husain

Can you post a sample excel file for experimenting?

Dave Kong

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
ASKER CERTIFIED SOLUTION
Saqib Husain

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Dave Kong

ASKER
Syed:

That is fantastic!  Bravo!  I am holding on to this sample.  

Thank you!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Dave Kong

ASKER
If I can quote Boogie Nights:  "genius... genius!".

Dave
Saqib Husain

Do you want to close the question or is there something else needed?


Dave Kong

ASKER
You can close the question.  Thank you very, very much!
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Saqib Husain

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.