Scroll Bars on a Gantt Chart

[Karl]

Hi all,

Looking for a little help.

I have put together a Gantt chart for the project I am running, however it's rather large and doesn't look great.

I've been able to successfully add a scroll bar to move the data horizontally but can't make the vertical scroll bar work in conjunction with it (so that I can go in either direction and get the right data).

Any help would be appreciated.

 

[Hui]

Typically you have a data source
Controls
and a Reporting section

The controls, control how the data is reported and so gives the illusion of scrolling

If you post a sample file here we can be more specific

 

[Karl]

Hi Hui,

I've attached a very basic version of what I have built (all sensitive data removed).

I can get the date range to move left to right but the sections E5 to K15 only go top to bottom.

Thanks in advance.

 

[NARAYANK991]

Hi,

See the uploaded file.

Narayan

 

[Karl]

Thank you Nara, that's amazing.

What was I doing wrong?

 

[NARAYANK991]

Hi Karl ,

The problem was that the formula was not making use of the scroll bar's linked cell value.

The formula in place was :

=OFFSET('Gantt Chart'!E5,Control!$C$2,0)

where the parameter highlighted in GREEN was making use of the vertical scroll bar's linked cell value ; the parameter highlighted in RED was a fixed value 0 ; this should have made use of the horizontal scroll bar's linked cell value.

The changed formula in place is :

=OFFSET('Gantt Chart'!E5,Control!$C$2,Control!$C$5-1)

where the highlighted reference is the value in the linked cell of the horizontal scroll bar.

Narayan