Home>Blogs>Excel Tips and Tricks>Analog Clock in Excel (Pie Chart + Doughnut Chart)
Analog Clock
Excel Tips and Tricks

Analog Clock in Excel (Pie Chart + Doughnut Chart)

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.

Below is the image of stunning Analog clocks-

 

Analog Clock in Excel
Analog Clock in Excel 
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

 

 

Visit our YouTube channel to learn step-by-step video tutorials

Youtube.com/@PKAnExcelExpert

Watch the step by step video tutorial:

 

PK
Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!
https://www.pk-anexcelexpert.com

Leave a Reply