Gantt Chart with ScrollBar...Problem!

[Dillina]

Good afternoon guys
(Sorry for my english)

When I read your solutions, I am always amazed. Congratulations!

I am trying to understand how I can create a Gantt Chart with scrollbar.

I tried but I'm wrong in something. Maybe I do not have to use OFFSET?
I am very curious about your opinions.

Is possible without VBA?

 

[NARAYANK991]

Hi ,

Can you explain what should happen when the user changes the scrollbar ?

Please post a screenshot of what the chart should look like.

Narayan

 

[Hui]

Change the X Axis Minimum and Maximum to Automatic
Also set the Major Units to 7



Without Using VBA it is not possible to set the X Axis Min and Max where the data extends past the Min or Max values

 

[Dillina]

@Narayan
Hello and thanks for replying
Sometimes due to problems of "space" it is not possible to see a complete view. I would like to see a complete year moving the scrollbar.
I have more years in the original file ...

@Hui
Hello!! Yes, I tried to do it, but my problem is that the "Activities" disappear .... but I would like to fix them. And that only changed the X axis


Chicos, Maybe I have to change a graph and only need a scollbar (no start date and no end date?) It could be good also like this......
Does this need the VBA too?

In the picture I pasted it manually to make you understand

https://imgur.com/a/om5O8

 

[vletm]

Dillina
... something like this
... but others would show how to do this ... otherway

 

[Dillina]

Dillina
... something like this
... but others would show how to do this ... otherway

It seems to me an excellent solution Vletm
Let me check if that's what I'm looking for (I do not trust myself much )
I'll give you feedback as soon as possible
Thanks

 

[vletm]

Dillina
Even I would do it other way ...
I tried that not change 'everything' from Your idea.
But all depends, what You would like to see and have?

 

[Dillina]

Dillina
Even I would do it other way ...
I tried that not change 'everything' from Your idea.
But all depends, what You would like to see and have?

Any advice is welcome !!!!

I tell you simply what I would like.
Scroll a horizontal bar (like yours) and see the evolution of the year, without changing the axes.

You know when you have a half-open Excel window on your desktop and you have the scroll bars on the right and bottom?

This is !! ... I would like that scroll bar below without changing the axes.
I'm crazy? You can tell me eh !!!
Sorry for english but google is helping me

 

[Hui]

Here is how I would implement this
I have changed the Named Formula so they collect all the data
I have changed the end date to be the Duration or Number of days
There are 2 macro's one for each scroll bar
they update the chart's Max and Min values according to E2 and H2

Enjoy

 

[vletm]

Dillina
Other version for You.
Data is in own sheet. You can use 'top-buttons' as needed.
You can add as many rows as You want.
Gantt:
There are two scrollbars an You can test ...
Sorry for italian but google is helping me

 

[Dillina]

Here is how I would implement this
I have changed the Named Formula so they collect all the data
I have changed the end date to be the Duration or Number of days
There are 2 macro's one for each scroll bar
they update the chart's Max and Min values according to E2 and H2
Enjoy

It's fantastic like all your solutions
Only one thing ... every time I click on the scrollbar the data on the left
"select" all .... Is it possible that this "selection" does not appear?

Grazie

 

[Dillina]

Dillina
Other version for You.
Data is in own sheet. You can use 'top-buttons' as needed.
You can add as many rows as You want.
Gantt:
There are two scrollbars an You can test ...
Sorry for italian but google is helping me

WOW!! Che bello!!!!
It's beautiful, give me time to watch it well !!
Tonight I answer you calmly ...
Thanks so much!!!
L'italiano è perfetto!!!

 

[vletm]

Dillina
Grazie, Grazie
Prova a dire come l'hai fatto

 

[Dillina]

Dillina
Grazie, Grazie
Prova a dire come l'hai fatto

How did you do it?
me and the vba we punch (i don't know if is correct to say)
and the xslb extension is the first time in my life that I see it
This evening I will try to understand it (now I can not)
But it will very difficult for me to understand, I miss the basics of vba

 

[Hui]

see revised file attached

 

[vletm]

Dillina
How did you do it?
I tried to figure what have You tried to think ...
.xlsb ... everything has once, the first time ...
What do You mean with Your d-i-f-f-i-c-u-l-t -word?
It's one step to learn...
"basti pensare ... apprendimento eterno"
or how do You would write it?

 

[Dillina]

see revised file attached

Fantastic Hui!!!
Grazie mille!!

 

[Dillina]

Dillina
How did you do it?
I tried to figure what have You tried to think ...
.xlsb ... everything has once, the first time ...
What do You mean with Your d-i-f-f-i-c-u-l-t -word?
It's one step to learn...
"basti pensare ... apprendimento eterno"
or how do You would write it?

You're right ... want is power!
Volere è potere...in italiano!!
It's time that's missing ... everyone's problem.
And I guarantee you that it's not an excuse.
In the last two years I discovered Excel and I fell in love with the power that he has, but still nothing vba ... next step ... I promise

 

[vletm]

Dillina
I still thinking about Your ... Gantt.
Did You wanted to select those 'Monthly'?
I tested ...
Left - You could select number of months
Top - You could select the first month to show
... I add more 'data' ... and this looks to work?
Ps. Everyone has 24hrs per day ... ooo ...
... only the first day and the last day could be shorter.
Do Small Tiny Steps ...

 

[Dillina]

Dillina
I still thinking about Your ... Gantt.
Did You wanted to select those 'Monthly'?
I tested ...
Left - You could select number of months
Top - You could select the first month to show
... I add more 'data' ... and this looks to work?
Ps. Everyone has 24hrs per day ... ooo ...
... only the first day and the last day could be shorter.
Do Small Tiny Steps ...

@vletm
sorry for waiting, but today full day ...
WOW more and more beautiful this GANTT !!! : D

I would need 48 hours ... not 24!
I have to find the time to study this new Gantt ... it's very nice and professional !!
You are very kind and sorry if I don't answer you in time ...