Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Gantt chart for yearly quarters rather than dates

Hurlz
in FileMaker Pro 18

Featured Replies

Hi there, I attach a sample database producing a Gantt chart for each day of the month supplied by directimpactsolutions.com  Works brilliantly. However, I need to produce the same effect but for each calendar quarter (Q1 = Jan, Feb, March; Q2 = April, May, June; Q3 = July, Aug, Sept; Q4 = Oct, Nov, Dec).

Can anyone advise on how to change this to produce something similar to the spreadsheet attached (used for display purposes only)?

Thank you 

Gantt by Qtrs.xls Gantt Chart (unlocked).fmp12

What would you expect a quarter partially occupied by a task to look like?

  • Author

Good question. As this is an overview document for senior management, I would envisage either a) divided into 3rds - one for each month of the quarter, or b) just the whole quarter coloured in.

2 hours ago, Hurlz said:

divided into 3rds - one for each month of the quarter

I believe that would make it a monthly chart, not a quarterly one.

Anyway, have a look at the attached demo. 

 

GanttQtrChartR.fmp12

    •
    • Like 1
    • Thanks 1
    • Author

    Yes you are right it would. What you have done is perfect!! Thank you so much.

    Create an account or sign in to comment

    https://fmforums.com/topic/107268-gantt-chart-for-yearly-quarters-rather-than-dates/
    Go to topic listing

    Similar Content

    Important Information

    By using this site, you agree to our Terms of Use.

    I accept

    Configure browser push notifications
    Chrome (Android)
    1. Tap the lock icon next to the address bar.
    2. Tap Permissions → Notifications.
    3. Adjust your preference.
    Chrome (Desktop)
    1. Click the padlock icon in the address bar.
    2. Select Site settings.
    3. Find Notifications and adjust your preference.