Excel Help--Scoring and Charting

I have (inherited) an excel database, and it corresponds to a chart. I have an identifier column, likelihood column, impact column, and a scoring column. It looks something like this:

A   B   C   D
1   ID  LK  IM  SC    
2   A1  2   3   6  
3   A2  3   3   9  
4   A3  4   2   8

These are then manually mapped onto a chart in Excel. We like the way it looks. If we can't keep the way it looks, we will not automate it. But is there any way to automate it? The chart looks like this:

In ours, the numbers in the heatmap would be the "A1", "A2", and "A3". For us, there are 9 cells in each block, as there are up to 10 in a single block.

Is there any way to program it so that when Excel sees that cells C2 and C3 are a 2 and a 3, it charts "A1" in the corresponding block on the heat map?

You chart doesn't make sense to me so I'm probably not the one to help, but I'm guessing you already know about conditional formatting? Because that's where I'd start to look. You could use a pivot table help automate it...maybe.

Google Vlookup and Conditional formatting that will allow you to automate the color heatmap chart so that it pulls the hard coded valued on the first sheet.

I'll be number three that doesnt understand what your describing for the chart.

Very loosely though, i will say if youve got a chart now you can make it refresh with new data.

I think I understand what you're saying, I'm no Excel expert but this sounds like the right solution:

DanyloS wrote: Google Vlookup and Conditional formatting that will allow you to automate the color heatmap chart so that it pulls the hard coded valued on the first sheet.

Looks to me like one of those charts used in D&D

RossD and DanyloS have put you on the right track. If I can get back to you this afternoon I'll try to help.