heat map

Okay, so i have a table in Excel as shown in c5-h10 below (a heat map). Column C and Row 10 are like the X and Y axis, giving the total max scores. Cell C3 is a multiple of frequency and severity. My goal is to have the result '10' in cell H8 showing as a darker boarder cell, and potentially...

Hello, First post on here but have used this site countless times as a reference. I am creating a heat chart for staffing purposes to show how many people are on shift for a specific day/time. The first sheet has schedule info (Name, Start Time, End Time, and 1/0 for each day of the week...

Hi All Excel Guru's, My first post here so please accept my apologies if I am out of line. Question: (Worksheet attached) I have a workbook with two separate Tabs Tab 1 - Floor Plan: Master Warehouse Map with Locations Tab 2 - Damages : List of Damages in the warehouse I have identified...

I am trying to build a heat map of a system I am working on. Here is a sample file with the bare bones: File Hosting - Free File Upload. Filehostfree On the model tab I have the layout I want to use. This is all hard coded and referred to throughout the document to make changes a one-place...

Hello, I am hoping someone can help me figure this one out. I have a sheet with a list of numbers on it (numbers can be 1-50): Example: <tbody> 1 2 3 2 2 3 2 2 1 3 1 2 1 1 2 </tbody> and another sheet in the same workbook which I have set with COUNTIF to count the number of times a...

Hi, i am new to the forum and was looking for some help. i have recently been asked to produce MI for a new business unit but all my excel skills are self taught and i have no idea where to even begin. I am limited by the work systems so i cannot export the data to work from my own laptop and i...