Can we creat heat map chart?

[#1]

Hello everyone,

Can we create heat map chart? Please see attached excel file for detail.

Thank you very much in advance!

Best regards,.

[MarcoWedel]

Hi,

maybe helpful:

Working with a Risk Map

regards

Marco

[MarcoWedel · Accepted solution]

or using your data and a scatter chart instead of a pivot table:

hope this helps

regards

Marco

[#4]

Thank you - Marco.

You solution is very close to what I need. Is there any possible I can have three colors gradient on background color?

Appreciate your help.

[#5]

I used an image for plot background. The chart looks good now. Please see attached QVW.

Do you guys have good idea to put this legends?

Best regards.

[MarcoWedel]

Hi,

glad you liked it.

How would this three colour gradient look like? Do you have an example?

regards

Marco