information like a heat map

[#1]

Hello,

I have a question regarding something like a heat map.

I want to create information boxes based on data i collect every week.

The should be boxes as much as i have machines in my plant and the information should be collected from an excel sheet.

Does somebody know how i can create something like shown in the screenshot (first is the template, the colored one are the examples).

Thanks, Armin

[MarcoWedel]

Hi,

maybe a pivot table could be a solution.

regards

Marco