You can build a Punchcard with the help of the Bubble Pie chart type.

Use сaseLink to 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 tableLink to 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

SolutionLink to 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.