Healthcare KPI dashboard
Healthcare KPI dashboard template is our first attempt to develop infographics style dashboard in Excel using male and female infogaphics elements.
We hope you will find this excel template useful!
Our goal is tracking and analysing the most important healthcare quality information of human body.
We’ll use an exclusive visual design and style which helps you to identify the key performance indicators and the overall performance. The first question: How to effectively track and accomplish our goals?
Healthcare KPI Dashboard – Design & Functions
We divided the male and female vector shapes into nine shape groups. The first 8 slicer display the health of a body part (percentage), the last one visualize the overall health status.
How to visualize data on a human map? The value based color mapping method (using our well-tried vba map engine) will perfect for us! OK, go to the next section.
Healthcare KPI Dashboard – Color Panel
On the Sheet ’calc’ fill in a line for each dimension value you want to set up. On the right side of the picture you can find the values area.
Here is a list of some parts of the body that have been included both male and female heatmap: Brain, Lungs, Heart, Liver, Stomach, Knee, Leg and Foot. You can change these elements of a human chart if you want.
Check on the middle of the picture! We prepared three bulit-in color themes for you: white to blue, white to green and the classic red to green. But you can override the predefinied settings for colors without a trouble.
Finally on the left side of the screenshot see the scale and the currently selected colors.
The color scale divided into 16 sections using PERCENTILE function. The default parameter of minimum value is 0, the default parameter of maximum value is 100.
Thank you for visiting our excel online dashboard magazine, it’s time to download our excel dashboard template!