Subscribe
Happy christmas to all valuable members,
I want to build up stocks heat map with 4 angel
here with share a photo copy of what i want & Raw data
https://docs.google.com/open?id=0B01xhb1Lk7tmdTFzV2xBRjN0SmM
Thanks
dahval Shah
HOW TO BUILD UP STOCKS HEAT MAP
(9 posts) (2 voices)-
Hi d380113,
Please see this file, i will try to improve it:
http://dl.dropbox.com/u/60644346/heat%20map.xlsm
Need your feedback,
Regards,
Posted 5 months ago # -
Hi D380013,
Sorry for late reply, i just reached my office when you posted the second last comment. You can put i manually on X-Axis or simply use a combination of INDEX() and MATCH() to bring numerical values from sheet2 to the final chart!!
Hope that helps,
Regards,
Posted 5 months ago # -
Dear Faseeh,
When i am try to change the data in Data Sheet heat map dosent work i am puting new data in sheet 01012013 ( pls check ) is it any hidden formulas ???
https://docs.google.com/open?id=0B01xhb1Lk7tmbW14SE9YTTIwOG8
Posted 5 months ago # -
Hi d380013,
Thank for feedback. Please note that you need to adjust the following ranges according to maximum and minimum in your data set, I just changed it for you so that you can understand:
-60 A -25% R -30 B 0% S 0 C 25% T 30 D 50% U 60 E 75% V 100% W..Please note that if you add extra categories to this work book you will need to adjust the combination of the two (AR, AS, AT....so on ) in the Sheet "RoughWork" in 11, 12 & 13th row.
Here is the reworked file:
http://dl.dropbox.com/u/60644346/d380013_Reworked.xlsm
Hope that works!
Regards,
Posted 5 months ago #
Reply
You must log in to post.
Welcome to Chandoo.org. New here?
Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.
