In this tutorial we will discuss about dynamic chart and how to create one with the options in drop down list.
The steps to follow:
1. Create drop down list.
2. Create a sub table of the main table using "index-match" formula.
3. Create a chart using the sub table.
Use this technique to create amazing dashboard for work, for your assignments or for yourself when you are bored 😉.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Please subscribe to our channel and click on the notification 🔔 so that you get notified every time we upload new videos.
Thank you. 😊
Ещё видео!