Tech Ease podcast

How to Build an Annual Process Year Wheel in SharePoint with Copilot

17/11/2026
0:00
5:53
Reculer de 15 secondes
Avancer de 15 secondes

Yes. An annual processes list in SharePoint can show the whole year as an interactive year wheel, built with Copilot in SharePoint and D3.js from five prompts.

An annual processes list tells you when things happen, but readers still have to piece the year together. In this Tech Ease episode, I walk through a SharePoint year wheel: months around the center, one colored ring per department, and every process drawn as a curved bar across the months it runs. Department filters, month selection, a process-count chart and a Back to today button help people explore what applies to them. The sample uses 30 made-up processes for a fictional company, across seven departments. The skill package is ready to download.

Chapters

0:00 Could your list show the whole year?

0:27 Where the idea came from

0:41 The year wheel I built

1:06 Select, hover, filter and rotate

1:44 Who connects the dates?

2:06 The five prompts

2:22 Prompt 1: Create the list

2:43 Prompt 2: Fill it with sample data

3:05 Prompt 3: Build the D3 year wheel

3:48 Prompt 4: Add animation and interaction

4:35 Prompt 5: Add the manager summary

5:00 Live from the SharePoint list

5:09 When a wheel is the right view

5:30 Try it yourself

The five prompts, in order (full text is in the pinned comment on the YouTube video):

1. Create the list

2. Fill it with sample data

3. Build the D3 year wheel

4. Add animation and interaction

5. Add the manager summary

Run them one at a time and check each result before the next.

Tips

Keep Start Month and End Month as number columns. The wheel is only as clear as the start month, end month and department in your list. Check after each prompt, and ask Copilot to remove any extra ring or glow you did not ask for.

Try the live year wheel: https://anandragav.github.io/copilot-html-dashboards/annual-processes-year-wheel/

Download the skill package (.zip): https://github.com/anandragav/copilot-html-dashboards/releases/download/annual-processes-year-wheel-v1/annual-processes-year-wheel-skill.zip

More sample dashboards: https://anandragav.github.io/copilot-html-dashboards/

Watch on YouTube: https://youtu.be/VRtjFYBzsl4

Tech Ease on YouTube: https://www.youtube.com/@anandvijayaragavan18

Follow Tech Ease on Spotify: https://open.spotify.com/show/0Cd8NsDE7kdQmLnbXe8Xx1

D'autres épisodes de "Tech Ease"