April 15th, 2011, 11:22 am
Dear Quants,I've just signed up for this forum and I like it already. I thought I'd post a MS Excel probelm here that I've been pondering on for a while. Maybe someone knows the answer. Here's what I want to go:I want to put a map of Europe into xls and format each country in a different colour (to show various risk scenarios). The whole thing should be linked to my rating model. The ratings are based on various economic factors. I've designed the model so that you can vary the inputs (eco data) and the output values then assume different colours since the model is for a presentation. Right now, I just have cells with the country names in them, but I figure it would look much more impressive, if I had a map instead and the whole country changed colour.I thought of formatting the cells into tiny little squares and then manually mapping the countries like that. Does anyone have a better method?Thanks!YH