I've been tasked with looking for replacements for our current KPI system as we move from Sharepoint 2013 to Sharepoint Online.
In our current system we use a KPI web part that hooks into Excel Spreadsheets and displays the data on web pages in a standard KPI display.
I've already found some options for going to online, the spreadsheets can be displayed directly on the page if we want, I can use formatted columns in a Sharepoint List for a dynamic KPI display but it doesn't hook into the Excel Spreadsheet as far as I know such that updating the spreadsheet updates the list. Or we can use Microsoft Dynamics, which is expensive and I don't know if it can hook into Excel Spreadsheets.
Is there another option for hooking into an Excel Spreadsheet hosted in a Sharepoint library and displaying the data in Sharepoint Online in a KPI format?