Weekly Hour Heatmap

Description:

Weekly Hour Heat-map Excel Add-In visualizes the hourly time series data in a heat-map for data analysis and tracking.

There are 3 color themes in the setting window.

This add-in supports up to 7 days (1 week), 24 hours per day visualization. The day labels can be selected in the setting window.

A sample data is provided to show the data:

• The first column is the number of the day (integer) range from 1 to 7.

• The second column is the number of the hour (integer) range from 1 to 24.

• The third column is the float data value.

Features:

• Mouse over the heat-map to view the data detail in the tool-tips.

• Easy to use and user-friendly. Sample data can be the template to build own data.

• Interactive Chart: the chart is binding to the data table in the sheet. The chart is updating when the data is entered.

Instruction:

• Download this add in and start Excel 2013 or later.

• Select a color theme in the color drop-down.

• Select a day label format in the drop-down.

• Click insert sample data button.

• Update the value columns with own data as needed.

• The heat-map is binding to the table. The map is updating when the data is entered.

• Rename the map title by clicking in the title area and reenter the name as preferred.