Gantt chart with calendar (use case)
You can build a Gantt chart with calendar with the help of the Gantt chart type.
Use case
You need to create a Gantt chart with calendar (to show working days by weeks at the bottom of the chart).
Source table
Your source tables look like the tables below. The first one can be manually created or come from Jira (you can use the Jira Issues macro, we mean).
Sprint | Key | Start | End | Completion Ratio |
|---|---|---|---|---|
Sprint 1 | ECS-93 | 10 Mar 2025 | 13 Mar 2025 | 100% |
Sprint 1 | ECS-48 | 15 Mar 2025 | 22 Mar 2025 | 100% |
Sprint 1 | ECS-62 | 10 Mar 2025 | 29 Mar 2025 | 100% |
Sprint 2 | ECS-61 | 15 Mar 2025 | 22 Mar 2025 | 80% |
Sprint 2 | ECS-99 | 24 Mar 2025 | 29 Mar 2025 | 70% |
Sprint | Milestone | Date |
|---|---|---|
Sprint 1 | RC-1 | 19 Mar 2025 |
Sprint 2 | RC-2 | 26 Mar 2025 |
Event | Date |
|---|---|
Today | today |
AP-40 | 18 Mar 2025 |
EP-20 | 26 Mar 2025 |
Calendar | Weeks | C.start | C.end |
|---|---|---|---|
Calendar | Week 1 | 10 Mar 2025 | 15 Mar 2025 |
Calendar | Week 2 | 17 Mar 2025 | 22 Mar 2025 |
Calendar | Week 3 | 24 Mar 2025 | 29 Mar 2025 |
Solution
- Wrap all the source tables (and Jira macros) with the Chart from Table macro.
- Choose the Gantt chart type.
- Set the required Labels and Values columns.
- Specify the correct Date format and other options if needed.
