In this article, we have created Chart Tooltip in KPI Dashboard in Microsoft Excel. You can use this trick to show the details of a number with the chart.
We have taken 3 KPIs here – Service Level, Sales Amount, and Attendance%. We are showing Quarterly Service Level Tooltip for Service Level, Sales by Country, Team Leader wise Attendance% on Tooltip.
KPI Dashboard with Tooltip in Excel
This is a ready to use template. You can customize it with our own data. You can also add more KPIs as per your requirements.
![Tooltip in KPI Dashboard](https://www.pk-anexcelexpert.com/wp-content/uploads/2021/08/Tooltip-in-Excel-1.jpg)
To show the tooltip, you need to check the Show Tooltip check box and then select the related option button in Tooltip Column.
![Show Tooltip button](https://www.pk-anexcelexpert.com/wp-content/uploads/2021/08/Tooltip-in-Excel-2-scaled.jpg)
Visit our YouTube channel to learn step-by-step video tutorials