Forum Discussion
SawkatAli
Oct 04, 2021Copper Contributor
How to make dashboard using dynamic images for a group of employee/ people?
Good day!
I am a HR Professional and doing a dashboard using slicer and dynamic images within a group using excel but can't finish.
If you are willing to help me to solve my problem, I will be very thankful to you.
Details:
- 22 employee
- Divided in 2 categories [Performance and Potential]
- Individual category has 5 different results [Outstanding, Very Good, Good, Average, Poor]
File Attached:
- Full Database with Question
I want to show some different and dynamic dashboard to my management.
I Cordially request you to help me, please.
Thanks,
Sawkat Ali
=======
Thanks,
Sawkat Ali
=======
- Create a new named range where will be the ImageFrameResult using the formula INDIRECT() with reference to the DropDown list1
Repeat the same process for each dropdown list you want to update an image frame.
4 Replies
Sort By
- Juliano-PetrukioBronze Contributor
- Create a new named range where will be the ImageFrameResult using the formula INDIRECT() with reference to the DropDown list1
Repeat the same process for each dropdown list you want to update an image frame.
- SawkatAliCopper Contributor
Thank you for your time.
Sorry for my new quarry, in previous it was not clear from my side.
[Excel file also attached for clear explanations]
Cordially requested to solve my problem.
- Juliano-PetrukioBronze ContributorTo be honest I would not do such thing with Excel. I would prefer Power BI rather Excel.
Well, what you need to do is plan your project.
How many frames will be shown?
How to identify the names (Create a table with ranked names)?
What I meant with ImageFrameResult means 1 (one) frame containing the desired result.
If you desire more frames will will need to apply the same technique for each frame (each employee I mean).
BestFrm1,BestFrm2,etc. and of course a table containing the ranked names so you can apply the INDIRECT() formula.