I have simply split the employee column into two sections: IT employees and non-IT employees. Let’s now consider a different example using a Dropdown form control.Īgain on the left side notice the data source table. I tend to usually overlay the Form Controls over the chart itself so it is more obvious for the user that the chart is dynamic.įor Excel 2013 users – you can also use timeline scrollbars natively in PivotTables/Charts (available on the Analyze ribbon tab). By scrolling the ScrollBar notice that the formulas will automatically recalculate and the chart will refresh to show only values above the cut-off. Notice that the Total formula take the value from the ScrollBar to set the current cut-off. Total – the number to be presented in the chart cut off by the ScrollBar (only showing values above).of employees – number of employees in the company On the left there is a simple table with 3 columns: Let’s consider a first example with a ScrollBar. This opens a whole lot of different possibilities to use Form Controls in calculations/charts etc.Įxample Form Control Properties Dynamic Excel Charts with a ScrollBar Notice especially the Cell Link property which will output the current value of the Form Control (in this case the scroll value). Look below for an example of how the ScrollBar properties look like. What makes Form Controls special? They are configurable and can be linked to cells in your Excel Workbook. Online Telerik controls have a Cascading DropDownList for this. I prepared a simple data set consisting of countries and associated cities. STEP 1Prepare source data for the drop-downs Simply repeat these steps to create additional cascading drop-downs levels.
Let’s go through the simple steps of creating a 1 level cascading drop-down consisting of 2 drop-downs. What to play with a online example? Telerik controls have a nice mock-up Cascading DropDownList for this. drill-down from store department, through the products lane, down till the product family and finally the product SKU. You can have any amount of cascading drop-downs e.g. What is a cascading drop-down?Ĭascading drop-downs are drop-downs that filter their values based on the selection made on another drop-down (higher in the hierarchy). Normally you would start by assigning a category to each record and then have a problem with matching a subcategory. Say you have a list of records you want to associate with categories and subcategories. EXCEL Tip of the Day: Cascading drop-down (no VBA!)Ĭascading drop-down are a very useful feature in Excel making it much easier to categorize your records.
0 kommentar(er)
