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.

Project Portfolio Gantt view scroll bar (right side)

Discussion in 'Questions about Chandoo.org Products' started by hotsummer70, Oct 19, 2017.

  1. hotsummer70

    hotsummer70 New Member

    Messages:
    3
    I purchased the Project Portfolio Dashboard and the right side scroll bar (Dashboard tab, Gnatt chart view) isn't there for 2007 or 2010 version. I am currently using Excel 2013. I have more than 15 tasks and currently not able to view task 16 forward.

    I really like the tool but without this feature, the tool is a no/go for me.

    Please help!
  2. hotsummer70

    hotsummer70 New Member

    Messages:
    3
    Solved the problem - The Gnatt chart view needed to be adjusted, it was covering the scroll bar.
  3. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    16,555
    Hi ,

    In case you want support on any of Chandoo's templates , please communicate by email to :

    tech.support@chandoo.org

    Narayan
  4. William Metz

    William Metz New Member

    Messages:
    4
    I have the same issue, how do you adjust the Gantt chart so it is not covering the scroll bar?
  5. William Metz

    William Metz New Member

    Messages:
    4
    Solved by un-protecting the sheet and resizing the Gantt chart, when I re-protect the sheet is there anything I need check on the leave un-protected list?
  6. William Metz

    William Metz New Member

    Messages:
    4
    Another question related to the Gantt chart, is it possible to expand the width of the Activity Name and reduce the width of the Calendar portion of the chart?
  7. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    16,555
    Hi ,

    Your first problem will not be resolved by manually resizing the Gantt chart.

    The workbook has a macro named resizeGantt , which is called from the Workbook_Open macro. Thus , the next time you open the workbook , this macro will run , and you will find that the Gantt chart is obscuring the vertical scroll bar on the right.

    Either you manually resize the Gantt chart , and then disable the resizeGantt macro by commenting it out , or you change the value used within the macro ; you will find the following line of code :

    .Width = 9.1 * 72

    Change the value 9.1 to 8.2

    For your second problem , you can send me the workbook to :

    tech.support@chandoo.org

    Narayan
  8. William Metz

    William Metz New Member

    Messages:
    4
    Thank you for your help, I updated the macro as suggested and it works fine now. I was able to resize the Activity name field by in-hiding the Gant sheet and adjusting the column width.
    thank you for your help.

Share This Page