Simple and Quick Visualization of Periodical Data Using Microsoft Excel

Abstract

Actograms are well-established methods used for visualizing periodic activity of animals in chronobiological research. They help in the understanding of the overall characteristics of rhythms and are instrumental in defining the direction of subsequent detailed analysis. Although there exists specialized software for creating actograms, new users such as students and researchers from other fields often find it inconvenient to use. In this study, we demonstrate a fast and easy method to create actograms using Microsoft Excel. As operations in Excel are simple and user-friendly, it takes only a few minutes to create an actogram. Using this method, it is possible to obtain a visual understanding of the characteristics of rhythms not only from typical activity data, but also from any kind of time-series data such as body temperature, blood sugar level, gene expressions, sleep electroencephalogram, heartbeat, and so on. The actogram thus created can also be converted to the "heatogram” shown by color temperature. As opposed to conventional chronograms, this new type of chronogram facilitates easy understanding of rhythmic features in a more intuitive manner. This method is therefore convenient and beneficial for a broad range of researchers including students as it aids in the better understanding of periodic phenomena from a large amount of time-series data.

Keywords

• actogram
• heatmap
• biological rhythm
• circadian clock
• chronobiology
• sleep pattern
• ecg
• eeg