Analog clock in Excel

[Sathish KV]

Hi Everyone,

Just thought to share this analog clock I have created in excel using Pie chart and vba

 

[vijay.vizzu]

Dear Satish...

Awesome.. but it wil be more interesting if you share the step wise procedure to achieve this

 

[Sathish KV]

Hi,

The clock needles are nothing but three Pie charts.

The minute pie's total area is 60 (60 minutes)
The second pie's total area is 60 (60 seconds)
The hour pie's total area is 12 (12 hours)

A macro splits your desktop time into hours, minutes and seconds and updates it every second in the excel (a samll dashord kind of thing in the active sheet)

The needle widh is already defined to differenciate between the hous, minute and second needles

The rest portion is arrived through formula (total area minus current , hour or minute or second)

The background and the numbers are just images

All the above combined creates an analog clock like effect

 

[ibeetb]

How do I get the background to be plain white? not blue and no patterns

Hi,

The clock needles are nothing but three Pie charts.

The minute pie's total area is 60 (60 minutes)
The second pie's total area is 60 (60 seconds)
The hour pie's total area is 12 (12 hours)

A macro splits your desktop time into hours, minutes and seconds and updates it every second in the excel (a samll dashord kind of thing in the active sheet)

The needle widh is already defined to differenciate between the hous, minute and second needles

The rest portion is arrived through formula (total area minus current , hour or minute or second)

The background and the numbers are just images

All the above combined creates an analog clock like effect

 

[Khalid NGO]

How do I get the background to be plain white? not blue and no patterns

Hi,

Background is actually an image, you can right click on picture and select Format Shape, Go to Fill and set color to your choice.