Gantt chart labels missing

W

wiseman

Please forgive me, I hardly ever use excel charts.
I wanted to make a gantt chart with time, so I download the gantt template
on

http://www.j-walk.com/ss/excel/files/general.htm

Then I used this article to change it to hours, and amazingly for a
Microsoft article it was really helpful
http://support.microsoft.com/?kbid=213915

However I now have a lovely Gantt chart in hours, but every other title on
the left (the tasks) is missing. I have tried making the font smaller and
the chart bigger but that has not helped.
I have searched in google groups, but not seen anything similar.

I would be really grateful for any other suggestions.
Thanks,
Barbara Wiseman.
 
D

Debra Dalgleish

Select the axis on the left
Choose Format>Selected Axis
On the Scale tab, set 'Number of categories between tick-mark labels'
to 1
Click OK
 
W

wiseman

Debra,
Thank you so much, this has solved my problem, it is so easy when you know
how.
Barbara.
 
D

Debra Dalgleish

Barbara,

You're welcome, and thanks for reporting that it worked.

And life would be really boring if we stuck to the stuff that we know
how to do!

Debra
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top