Interactive Production KPI Dashboard

Here is a nice Interactive Production KPI Dashboard that shows various KPI’s side by side for different company locations for easy comparison. It is also an interactive dashboard that can be filtered for months by a combo box.

Interactive Production KPI Shows following KPI’s:

  • Revenue
  • Profit
  • Efficiency
  • Turnover Rate

These KPI’s can easily be replaced by something else depending on your needs.

  • Changing content of cell A1 in each worksheet will change the KPI name for that slot.
  • Changing data in the worksheets will result as changing the KPI figures for that slot.

Interactive Production KPI Dashboard 1

All the tools used to create this Interactive Production KPI Dashboard are mentioned on the site:

IF Function

VLOOKUP Function

CHOOSE Function

Summing a Range of Cells that Contains Errors

Combo Box

Combining Two Charts

Minimalist Charts

To download this chart:

Download Interactive Production KPI Dashboard

Download FAQ

Feel free to leave a comment for any question or suggestion 🙂


You may also like...

5 Responses

  1. Habib says:

    Very helpful excel file from, please send me link, if some excel file contain following data cutting, bending, welding, powder coating, assembly, packing & dispatching option included with top 5 projects in progress, booked / schedule projects.

  2. Alberto Gutierrez says:

    Hi and thanks you for such a good help with your template . I am wondering how do you calculate the efficuency % as I do not undertand the excel formula. Thanks in advance

  1. February 25, 2020

    […] Download Image More @ […]

  2. March 26, 2020

    […] Download Image More @ […]

  3. May 18, 2020

    […] Download Image More @ […]

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.