Dynamic Shape Display in Your Excel Dashboard
6.3 هزار بار بازدید -
6 سال پیش
-
Dynamic Shape Display in Your
Dynamic Shape Display in Your Excel Dashboard. Checkout the Excel Dashboard Toolbox mentioned in the video here: https://gumroad.com/l/the-excel-dashb... and get 20% off using coupon code YOUTUBE20.
**About this Video**
In this video I go into how to create shapes and then dynamically display data in those shapes using a drop down list and combo box form. Here is the step by step process:
1) Use the VLOOKUP formulal with your combo box control on your calculations tab to looking and find information relating to the item selected in the drop down box in the Excel Dashboard. Use name ranges then for the values on the calculations tab so you can easily use them on the dashboard.
2) Build your visual dynamic shape display by adding the shapes you'd like with the text and information you want to display on the Excel dashboard. Once the shapes are there, you will select the Excel shape you want the shape to dynamically display and type in the formula box =(name range). Once you do this you can hit enter and it will automatically refer to the value on the calculations tab that will change based on the drop down selection made by the user.
3) After all of the shapes are dynamically displaying, you'll want to then freeze and lock shapes in Excel dashboard. This will allow the values to not be moved or edited by the user. They shapes will be locked and frozen. To do this use the review tab and then select protect worksheet.
*Related Resources and Links*
My Website : http://bradedgar.com
Excel Dashboard Tutorial #1 : Dynamically Highlight Rows in Excel Using Conditional Formatting - Dynamically Highlight Rows in Your Ex...
Step 4: Building the Excel Dashboard Display with Shapes with Name Range Associations - Step 4: Building the Excel Dashboard ...
How to Lock Shapes in Your Excel Dashboards - How to Lock Shapes in Your Excel Dash...
How to Use the Vlookup Formula in your Excel Dashboard
How to Use the Vlookup Formula in you...
How to Use the Excel Camera Tool
How to Use the Excel Camera Tool
#Excel #Dashboards
0:00 Introduction
0:01 THE EXCEL DASHBOARD TOOLBOX DYNAMICALLY DISPLAY DATA USING SHAPES
0:58 SETTING UP THE CALCULATIONS TAB
4:03 LINKING YOUR SHAPES TO YOUR CALCULATIONS
7:06 LOCKING THE SHAPES IN YOUR DASHBOARD
**About this Video**
In this video I go into how to create shapes and then dynamically display data in those shapes using a drop down list and combo box form. Here is the step by step process:
1) Use the VLOOKUP formulal with your combo box control on your calculations tab to looking and find information relating to the item selected in the drop down box in the Excel Dashboard. Use name ranges then for the values on the calculations tab so you can easily use them on the dashboard.
2) Build your visual dynamic shape display by adding the shapes you'd like with the text and information you want to display on the Excel dashboard. Once the shapes are there, you will select the Excel shape you want the shape to dynamically display and type in the formula box =(name range). Once you do this you can hit enter and it will automatically refer to the value on the calculations tab that will change based on the drop down selection made by the user.
3) After all of the shapes are dynamically displaying, you'll want to then freeze and lock shapes in Excel dashboard. This will allow the values to not be moved or edited by the user. They shapes will be locked and frozen. To do this use the review tab and then select protect worksheet.
*Related Resources and Links*
My Website : http://bradedgar.com
Excel Dashboard Tutorial #1 : Dynamically Highlight Rows in Excel Using Conditional Formatting - Dynamically Highlight Rows in Your Ex...
Step 4: Building the Excel Dashboard Display with Shapes with Name Range Associations - Step 4: Building the Excel Dashboard ...
How to Lock Shapes in Your Excel Dashboards - How to Lock Shapes in Your Excel Dash...
How to Use the Vlookup Formula in your Excel Dashboard
How to Use the Vlookup Formula in you...
How to Use the Excel Camera Tool
How to Use the Excel Camera Tool
#Excel #Dashboards
0:00 Introduction
0:01 THE EXCEL DASHBOARD TOOLBOX DYNAMICALLY DISPLAY DATA USING SHAPES
0:58 SETTING UP THE CALCULATIONS TAB
4:03 LINKING YOUR SHAPES TO YOUR CALCULATIONS
7:06 LOCKING THE SHAPES IN YOUR DASHBOARD
6 سال پیش
در تاریخ 1397/11/23 منتشر شده
است.
6,372
بـار بازدید شده