Lesson#109: Tricks to make a dancing chart in excel

Lesson#109: Tricks to make a dancing chart in excel

Here I will show you a funny trick to make a dancing chart in excel.

For that, you have to follow some steps.

1. Make a range of data names like A, B, C, and D…..

2. Then put values against these names with the RANDBETWEEN formula by putting any arbitrary lower and upper values.

3. Then select the whole data and insert a chart.

Now I will add some simple VBA to make the clock auto refreshed every second. So I have taken these simple steps.

Making an automatic analog clock in excel with pie chart

4. From the Developer Tab I have inserted a Button (Form Control) and clicked on New in the Assign Macro window

Making an automatic analog clock in excel with pie chart

5. Opening the VBA editor I added this code

Sub Button2_Click()
Call refreshcell
End Sub
Sub refreshcell()
Range(“a1”).Calculate
Application.OnTime Now + TimeValue(“00:00:1”), “refreshcell”
End Sub

6. Edited the button text and the size just looks good.

7. Save this sheet as a macro-enabled workbook in .xlsm format.

Now see every second this sheet is auto-refreshing the clock. I put that button to call the function refreshcell()
if the sheet doesn’t start to refresh itself automatically after opening it.

I have given the download link to the file. Click here to download.
See also  Lesson#4: What is Data Validation in Excel?

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

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

*