Microsoft Office Tutorials and References
In Depth Information
Figure 18-23: This workbook generates hypocycloid curves.
The chart itself is interesting enough, but it gets really interesting when it’s animated. The
animation occurs by changing the starting value for the series within a loop.
Creating a “clock” chart
Figure 18-24 shows an XY chart formatted to look like a clock. It not only looks like a clock, but it
also functions as a clock. I can’t think of a single reason why anyone would need to display a
clock like this on a worksheet, but creating the workbook was challenging, and you might find it
This workbook, named vba clock chart.xlsm , is available on the companion
Besides the clock chart, the workbook contains a text box that displays the time as a normal
string, as shown in Figure 18-25. Normally the text box is hidden, but you can display it by
deselecting the Analog Clock check box.