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

  1. Wrap the table with the Chart from Table macro.
  2. Choose the Bubble Pie chart type.
  3. Set the required X-axis, Y-axis columns and values column.
  4. Specify the correct Date format and other options if needed.