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"

x:
VBA.DoEvents
If sh.Range("N1").Value = "Stop" Then Exit Sub
Application.Calculate
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:

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 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.
https://www.pk-anexcelexpert.com

Leave a Reply

Your email address will not be published. Required fields are marked *