+ Reply to Thread
Results 1 to 4 of 4

Have the ability to view a daily Gantt chart as a monthly gantt chart

  1. #1
    Forum Contributor
    Join Date
    07-22-2015
    Location
    San Francisco
    MS-Off Ver
    Mac 2011 Version 14.5.2
    Posts
    107

    Have the ability to view a daily Gantt chart as a monthly gantt chart

    Hello,

    I have a gantt chart that is in a daily format (see attached). However, it now goes out until the end of 2019, so I have a need to switch between viewing it as a daily gantt chart and also a monthly gantt chart.

    Is it possible to do this?

    Any help appreciated
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Have the ability to view a daily Gantt chart as a monthly gantt chart

    I'm not quite sure what you're envisioning when you mention being able to "switch" between views, but it's pretty uncomplicated to create a mirroring sheet with a monthly Gantt. In the attachment, I simply copied your existing sheet, changed the dates to monthly dates using the following in L3, filled right as far as you need to:

    =EOMONTH(K3,0)+1

    I put the following in A4 and filled right through J4 and down, effectively creating a mirror of your daily sheet:

    =IF(Gantt!A4="","",Gantt!A4)

    I then tweaked the formula in K4 to:

    =IF(AND(EOMONTH(K$3,0)>=$G4,K$3<=WORKDAY($G4-1,$H4)),TRUE,FALSE)

    ...and filled right and down. Your conditional formatting should highlight any months included in the dates of each project. Everything on the monthly sheet should update automatically based on what you enter in your daily sheet. You can also fill all formulas right if you need more months or down if you need more rows for projects. Give the attachment a look to see if it'll do:
    Attached Files Attached Files
    If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".

    If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
    https://www.excelforum.com/the-water...ke-thread.html

  3. #3
    Forum Contributor
    Join Date
    07-22-2015
    Location
    San Francisco
    MS-Off Ver
    Mac 2011 Version 14.5.2
    Posts
    107

    Re: Have the ability to view a daily Gantt chart as a monthly gantt chart

    That does it.

    Thanks so much for taking the time to assist!

  4. #4
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Have the ability to view a daily Gantt chart as a monthly gantt chart

    Glad to help, good luck!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Employee daily schedule Gantt chart
    By ryesner in forum Excel General
    Replies: 1
    Last Post: 11-12-2017, 07:46 PM
  2. Dynamic in cell Daily/Hourly Gantt Chart
    By sorensjp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2017, 07:24 AM
  3. Excel Gantt chart to Calendar view
    By kriminaal in forum Excel General
    Replies: 1
    Last Post: 01-26-2017, 03:11 PM
  4. Monthly gridlines in Excel Gantt chart
    By colabarris in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-14-2016, 02:50 PM
  5. Date Formula - gantt chart view
    By kwill1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2014, 05:20 PM
  6. Replies: 5
    Last Post: 10-04-2012, 07:01 AM
  7. Replies: 0
    Last Post: 07-13-2012, 06:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1