Increase the number of Activities shown in "Gantt project chart1" (download from Excel templates)

Question

How to increase the number of Activities shown in "Gantt project chart1" (download from Excel templates)? The chart shows 5 activities in one time and scrolling the bar can show another five activities.&nbsp; Is it possible to show all activities in one page?

hansvogelaar · Answer

SHLam-ARK&nbsp;
Make the Excel window larger, or decrease the zoom percentage at which you view the sheet.

shlam-ark · Answer

HansVogelaar&nbsp;Dear Hans, Thank you for your help.&nbsp;The first picture is the original view; the second picture is the view of decreasing the zoom percentage to 50%.&nbsp; 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.&nbsp; Thank you.Best regards,S.H. Lam

hansvogelaar · Answer

SHLam-ARK&nbsp;
Aha - the chart had deliberately been designed to display only 5 categories at once.
I have completely removed this feature from the attached version.

shlam-ark · Answer

HansVogelaar&nbsp;Dear Hans,Thank you for your help.&nbsp; 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.&nbsp; Thanks again.Best regards,S.H. Lam&nbsp;&nbsp;

hansvogelaar · Answer

SHLam-ARK&nbsp;
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.

Forum Discussion

Increase the number of Activities shown in "Gantt project chart1" (download from Excel templates)

Share

Resources