Gantt chart for yearly quarters rather than dates

[Hurlz]

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

[comment]

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

[Hurlz]

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.

[comment]

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

[Hurlz]

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