1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Gantt Chart with ScrollBar...Problem!

Discussion in 'Discuss Data Visualizations and Charting' started by Dillina, Feb 3, 2018.

  1. Dillina

    Dillina Member

    Messages:
    35
    Good afternoon guys :)
    (Sorry for my english)

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

    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?

    Attached Files:

  2. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    16,555
    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
    Dillina likes this.
  3. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,351
    Change the X Axis Minimum and Maximum to Automatic
    Also set the Major Units to 7

    upload_2018-2-4_15-43-12.png

    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
    Thomas Kuriakose and Dillina like this.
  4. Dillina

    Dillina Member

    Messages:
    35
    @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?) :confused: 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
  5. vletm

    vletm Excel Ninja

    Messages:
    3,513
    Dillina
    ... something like this
    ... but others would show how to do this ... otherway

    Attached Files:

    Thomas Kuriakose and Dillina like this.
  6. Dillina

    Dillina Member

    Messages:
    35
    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 :oops:)
    I'll give you feedback as soon as possible
    Thanks;)
  7. vletm

    vletm Excel Ninja

    Messages:
    3,513
    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 likes this.
  8. Dillina

    Dillina Member

    Messages:
    35
    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 !!! :p
    Sorry for english but google is helping me :)
  9. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,351
    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

    Attached Files:

    Dillina likes this.
  10. vletm

    vletm Excel Ninja

    Messages:
    3,513
    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 :)

    Attached Files:

    Thomas Kuriakose and Dillina like this.
  11. Dillina

    Dillina Member

    Messages:
    35
    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 :)
  12. Dillina

    Dillina Member

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

    vletm Excel Ninja

    Messages:
    3,513
    Dillina
    Grazie, Grazie
    Prova a dire come l'hai fatto:DD
  14. Dillina

    Dillina Member

    Messages:
    35
    How did you do it? :eek:
    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 :oops:
  15. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,351
    see revised file attached

    Attached Files:

    Dillina likes this.
  16. vletm

    vletm Excel Ninja

    Messages:
    3,513
    Dillina
    How did you do it? :eek:
    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 likes this.
  17. Dillina

    Dillina Member

    Messages:
    35
    Fantastic Hui!!!
    Grazie mille!! :)
  18. Dillina

    Dillina Member

    Messages:
    35
    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 :)
  19. vletm

    vletm Excel Ninja

    Messages:
    3,513
    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 ...

    Attached Files:

    Dillina likes this.
  20. Dillina

    Dillina Member

    Messages:
    35
    @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 ...

Share This Page