Course Alert:
If you would like to learn in detail, how to calculate income statement variances and the impact they have on sales $, profit $ and profit margin % and ebitda %, and how to explain performance vs budget and prior periods, click on the link for a detailed video course (at a special price). You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel templates. https://ebitda.thinkific.com/courses/learn

Looking for more personalized help? Book a meeting with me: https://calendly.com/learnaf

Create Dynamic Excel Chart Using Drop Down list

Learn pivot table data crunching business skills here: https://amzn.to/3lgYB5E
Learn all about Excel in one place: https://amzn.to/3laCXQx

https://www.instagram.com/learnaccountingfinance
https://www.learnaccountingfinance.com

Subscribe: http://www.youtube.com/c/LearnAccountingFinance?sub_confirmation=1

In this Excel video tutorial, you will learn how to create dynamic Excel Chart using a Drop Down list. We will work with raw data, create a drop down list and then link the drop down list to the Chart data. The Chart data will be dynamic or dependent on the drop down list. As soon as you select the name of country from the drop down list, the chart data will be updated. This will also update the Chart itself. You will also learn how to link the Chart title to the selection from the drop down list. This way the Chart Title will be updated along with the Chart when you select the Name from the drop down list.

Functions Used:
Data Validation
Sumif Formula
Insert Chart Function
Line graph
Sum formula
& and inverted commas to combine text

Video how to create dependent drop down list: https://youtu.be/uY9jGaZf4bk

Video How to create drop down list that updates automatically
https://youtu.be/EnPkrU4zCAA