Excel Dynamic Chart with Drop down List - Excel Tips and Tricks - PART2

Creating dynamic charts and tables in Excel involves a few steps and features that enable interactivity and data visualization based on user selections. To create a dynamic chart from a set of dropdown data, you first need to set up a dependent drop-down list that can filter data dynamically. For instance, in creating a dynamic dependent drop-down list in Excel, you can use data validation. Select the cell for the drop-down list, go to Data ~ Data Tools ~ Data Validation, and under the Settings tab, choose List and set the Source as "Qty, Sales". For creating a dynamic table, use a formula like =CHOOSECOLS(B5:D19,1,MATCH(D2,B5:D5,0)) where the table updates based on the dropdown selection. Finally, to create a dynamic chart linked to this dropdown, select the dynamic table and press Alt + F1 to insert a chart that reflects the changes based on the dropdown selection. This approach is useful for creating interactive pivot tables and graphs, making data analysis more efficient and user-friendly.

Here's are the steps and formula feature in my video.

Create Drop Down
1) Select cell D2
2) Data ~ Data Tools ~ Data Validation
3) Setting tabs
4) List
5) Source set "Qty, Sales"

Dynamic Table
=CHOOSECOLS(B5:D19,1,MATCH(D2,B5:D5,0))

Dynamic Chart
1) Select dynamic table
2) Alt + F1

#tips #excel #shorts #fyp

[RajendraRout-qf]

Sir, i xtreamly request u please make a video, using sumif +xlookup+conditional formatting formula together