Excel Tricks: Automatic change of chart data

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

thank you, very useful;where do you get the temperature data?  

dibraniuk
Автор

Update: I solved the label updating issue by entering formula:=IF(O1=1, B1, IF(O1=2, C1, IF(O1=3, D1, IF(O1=4, E1, IF(O1=5, F1,

dibraniuk
Автор

This is very nice tutorial, but the title does not reflect its importance,  
Would you please change the title to "Miracles with excel: Automatic change of chart data". or something like that, I am sure you will get a bunch of more views if you do so.

drnesr