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 with some extra working in it (without getting rid of the number). That wording can be the same no matter what the 'total' is. So I was thinking maybe there is some way to make a picture and move it around my cells? Or some advanced conditional formatting? Or maybe even making a Graph and having the point move around as a scatter plot input, with the background as a picture showing my numbers?
- I think that last option sounds best, but I have no idea, any suggestions?
<tbody>
</tbody>dfg
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 with some extra working in it (without getting rid of the number). That wording can be the same no matter what the 'total' is. So I was thinking maybe there is some way to make a picture and move it around my cells? Or some advanced conditional formatting? Or maybe even making a Graph and having the point move around as a scatter plot input, with the background as a picture showing my numbers?
- I think that last option sounds best, but I have no idea, any suggestions?
a | b | c | d | e | f | g | h | i | |
1 | Frequency | 2 | |||||||
2 | Severity | 5 | |||||||
3 | Total | 10 | |||||||
4 | |||||||||
5 | 5 | 5 | 10 | 15 | 20 | 25 | |||
6 | 4 | 4 | 8 | 12 | 16 | 20 | |||
7 | frequency | 3 | 3 | 6 | 9 | 12 | 15 | ||
8 | 2 | 2 | 4 | 6 | 8 | "This Cell" 10 | |||
9 | 1 | 1 | 2 | 3 | 4 | 5 | |||
10 | 1 | 2 | 3 | 4 | 5 | ||||
11 | Severity |
<tbody>
</tbody>