Punchcard (use case)
You can build a Punchcard with the help of the Bubble Pie chart type.
Use сase
The table includes information on the number of commits by date and hour.
You need to get a commit summary with the help of a Punchcard.
Source table
Your source table looks like the table below.
Day of the week | Hours | Commits |
|---|---|---|
Mar 17 | 10:00 | 5 |
Mar 18 | 10:00 | 10 |
Mar 19 | 10:00 | 20 |
Mar 20 | 10:00 | 20 |
Mar 21 | 10:00 | 10 |
Mar 22 | 10:00 | 5 |
Mar 23 | 10:00 | 0 |
Mar 17 | 11:00 | 10 |
Mar 18 | 11:00 | 20 |
Mar 19 | 11:00 | 30 |
Mar 20 | 11:00 | 30 |
Mar 21 | 11:00 | 30 |
Mar 22 | 11:00 | 15 |
Mar 23 | 11:00 | 0 |
Mar 17 | 12:00 | 10 |
Mar 18 | 12:00 | 10 |
Mar 19 | 12:00 | 30 |
Mar 20 | 12:00 | 40 |
Mar 21 | 12:00 | 20 |
Mar 22 | 12:00 | 20 |
Mar 23 | 12:00 | 0 |
Mar 17 | 13:00 | 10 |
Mar 18 | 13:00 | 20 |
Mar 19 | 13:00 | 40 |
Mar 20 | 13:00 | 50 |
Mar 21 | 13:00 | 50 |
Mar 22 | 13:00 | 20 |
Mar 23 | 13:00 | 0 |
Mar 17 | 14:00 | 5 |
Mar 18 | 14:00 | 10 |
Mar 19 | 14:00 | 20 |
Mar 20 | 14:00 | 20 |
Mar 21 | 14:00 | 10 |
Mar 22 | 14:00 | 5 |
Mar 23 | 14:00 | 0 |
Solution
- Wrap the table with the Chart from Table macro.
- Choose the Bubble Pie chart type.
- Set the required X-axis, Y-axis columns and values column.
- Specify the correct Date format and other options if needed.
