Excel - How to create a chart based on drop down list | Excel Tips 110
In this Excel tutorial, you will learn How to create a chart that will be changed based on the value choosen from a drop down list | Excel Tips 110
Want to get 3 chapters of the Excel SuperHero book? Sing up: https://ExcelAndAdam.com/book
Used formula:
=CHOOSE(MATCH($F$1,$E$1:$E$3,0),Chart1,Chart2,Chart3)
--⏱️Timestamps⏱️--
00:00 | Creating shape connected to cells
01:49 | Creating formula to choose proper range for each chart
03:40 | Naming the formula for choosing a chart
04:54 | The End
================
Files to download in the Eng folder on the website:
http://exceliadam.pl/youtube
You can also find me on:
📚Blog - https://excelandadam.com/
🍀Instagram - / excelandadam
🌟Tik Tok - / excelandadam
✨Facebook - / excelandadam
🕊Twitter - / excelandadam
#ExcelAndAdam #ExcelTips #excel