In this tutorial, you will find the step-by-step process of creating a Dependent Drop Down List in Excel (aka conditional drop down list).
Learn how to create a Drop Down Filter in Excel. When you select an item from the drop down, it extracts the data based on the selection
Y Axis: =INDEX(KPIData,ROWS($A$15:B15),$B$9+1) Now this data is fed into a scatter chart. Since the data is dependent on the Combo Box drop downs, as soon as the drop-down selection is changed, the chart instantly updates.Download...