How can I add a slicer function or a task button into a gantt chart

[Bear]

Dear buddies



Attached is a Gantt chart showing a project under different milestones.


Is there any method that I add a slicer or a button at the top of the chart, say the 1st button is milestone 1, then milestone 2, then milestone 3….


The user can click the milestone button, then the Gantt chart just show the “Level 1” and specific “Milestone” only.

 

[vletm]

Bear
... or something like this
Press those [ Milestone ]-buttons as You need..

 

[Krishna Chaitanya P]

@vletm,

Please help me how did this possible

 

[vletm]

Krishna Chaitanya P
Many things are possible,
but need to know
what do You mean?

 

[Bear]

Dear buddies



Attached is a Gantt chart showing a project under different milestones.


Is there any method that I add a slicer or a button at the top of the chart, say the 1st button is milestone 1, then milestone 2, then milestone 3….


The user can click the milestone button, then the Gantt chart just show the “Level 1” and specific “Milestone” only.

Bear
... or something like this
Press those [ Milestone ]-buttons as You need..

Hi Vletm

Thank you so........MUCH!
I have been waiting for the reply for almost whole day, and no one reply it...I almost feel that I may give up..

Until I saw your reply.....really awesome.

Could you tell me what function did you use? Marco, VBA??

Also, I wanna add 1-2 milestones as well, could I just copy the button and revise the name

Once again, thank you very much....I do not know what to say

 

[vletm]

Bear
You can see everything from that file.
There are two kind of sample macros.
Use few seconds to check those and
with same method You can add more 'milestone's.
You can always say 'Bear'!

 

[Bear]

 

[Bear]

Bear
You can see everything from that file.
There are two kind of sample macros.
Use few seconds to check those and
with same method You can add more 'milestone's.
You can always say 'Bear'!

Hi vletm

I am afraid that I still have some difficulties to modify the gantt chart that you sent it to me earlier as I am not familiar the vba, could you do me a favour again? Attached is my final version of gantt chart, I have revised the button names and added 2 more buttons, could you help me to add/modify the vba coding again?

I am sorry that I bother you again, but I promise that I will learn VBA soon, it is really really.....useful

 

[vletm]

Bear
Do You know why sample file would be as close to real file?

 

[Bear]

I knew now. thank you so much!!
It is hard to find words to express my gratitude.