Analog Clock
Charts and Visualization Excel Tips and Tricks

Analog Clock in Excel (Pie Chart + Doughnut Chart)

After creating the Digital Clock, we have created a beautiful Analog Clock. This stunning Analog Clock we have developed using Pie Chart and Doughnut Chart. To calculate the formula automatically, we have used below given code.

Option Explicit

Sub Start_Clock()

Dim sh As Worksheet
Set sh = ActiveSheet

sh.Range("N1").Value = "Start"

If sh.Range("N1").Value = "Stop" Then Exit Sub
GoTo x

End Sub

Sub Stop_Clock()

Dim sh As Worksheet
Set sh = ActiveSheet

sh.Range("N1").Value = "Stop"

End Sub

Below is the image of stunning Analog clocks-

Analog Clock

Click here to download this Excel workbook.


Watch the step by step video tutorial:

My Name is PK. I am founder of I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.

Leave a Reply