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
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
is it possibale with Chart ? experts pls have a look
highly obliged
Thanks
Dhaval Shah
Ahmedabad,
M) 98240 35253
Hi d380013,
Welcome to the Forums!! Pleas wait for a couple of hours i will try to upload what i am working over.
Thanks
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,
Dear thanks a lot for u r feedback really excellent work & highly obliged
how to imporve in finalyy output in X & Y aixs instade of can we put 0 to 25 & 25 to 200 % ???
Dear Faseeh
really a gr88 help thanks a lot
Dhaval Shah
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,
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
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,
You must log in to post.