Forum Discussion
Increase the number of Activities shown in "Gantt project chart1" (download from Excel templates)
Dear Hans, Thank you for your help.
The first picture is the original view; the second picture is the view of decreasing the zoom percentage to 50%. There is no increase in the activities shown in the Gantt; there are 15 activities actually and I want to see all the activities in one view rather doing the scrolling. Thank you.
Best regards,
S.H. Lam
Aha - the chart had deliberately been designed to display only 5 categories at once.
I have completely removed this feature from the attached version.
Dear Hans,
Thank you for your help. That is what I need.
Do you think you can share how to remove that feature of showing 5 activities only? Please accept my apology and ignore my request if it is not appropriate to make such request. Thanks again.
Best regards,
S.H. Lam
The Project Tracker sheet had two hidden columns: F and G. I unhid those columns.
I then clicked on the chart on the Project Chart sheet and clicked Select Data on the Chart Design tab of the ribbon.
I edited the two series and the x-axis labels to point to the complete ranges, for example:
I removed the scroll bar below the sheet, and unhid, then deleted the hidden sheet that contained formulas used to display only 5 rows at a time.