Hi,
The attached file was created from a template available in Excel.
This file came with a project that is 2 month long.
As a farmer, my project is a year (season) long.
I want to be able to scroll the calendar to May e.g. without scrolling the sheet, so I want loose the tasks list.
Chatgpt suggested VBA-activeX control, but I want the calendar to display all the colors and progress of the tasks, and that, I believe, will require heavy VBA coding.
Is there a simpler way for this?
Regrads,
Ayal Telem.
not sure that I fully understand, though that template merely displays 8 weeks at the time. You probably can't see more on a mid-size screen anyway.
Enter 25 in Q1, for instance, and it will display weeks from mid-June to the beginning of August.
Select cell G8, then Freeze Panes. This will keep the task list and date headers in view, no matter how far you scroll right or down.
Would that help you?
By the way, this template is called "Simple Gantt chart" and that's exactly what it is, and its extensive use of merged cells indicates poor design.
Hi Ryni,
Stupid me, forgot about the Freeze option.
That will work, since I don't need don't need more than 1 month in display.
Thanks a million.
Ayal Telem.
