Tooltip in Excel
Charts and Visualization

KPI Dashboard with Tooltip in Excel

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.


Tooltip in KPI Dashboard
Tooltip in KPI Dashboard


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
Show Tooltip button

Watch the step by step video tutorial:

Click here to download the practice file.

My Name is PK. I am founder of I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.