Dashboard software for SME

Can anyone recommend a 'Dashboard' software that is simple to use and can produce the monthly KPI's in a simple form?

Currently accounts are produced on Sage 50, and combined with other data from the ERP system, payroll and forecasts to provide monthly reports mostly in chart form for the Directors and managers, which ultimately are quite concise and simple to look at.

Behind the scenes, this is a complex exercise using Excel. This is for a small company with only part-time finance staff, so is there an easy to use solution?

Or, am I missing a simple way of doing this on Excel? Add-ins are used to import  data and charts are drawn from this.

I would appreciate hearing how others have solved this problem.