Dashboard Ideas

**wherdzik** · 11-06-2020, 02:45 PM

I am looking for advice on the best way to create dashboards for individual employees. These would be their personal compensation and incentive payments based on their performance monthly and quarterly. I am thinking of creating multiple tables that would calculate their performance and output in a graphical way, dashboard feel and look. This would be created for over 200 employees, PDFed and emailed out to them each month. I guess I am thinking how to best do this, do I create an individual sheet for each employee, it may be too much for excel? or do I just create a template, and create some kind of vba that would palce in their employee ID and refresh all data. But thinking that these would be all pivot tables or charts. can vba handle that....like have it place an employee ID and the pivot tables and charts refresh with the data. anyone have done this in their organziation and can offer advice. I am not sure even if I am giving you enough information for you to give me ideas but any help is appreciated, I am shooting in the dark at this time.

Thank you kindly and stay safe everyone!

**vba_php** · 11-06-2020, 04:33 PM

there are a million different dashboard templates for excel. have you searched for them? you can do literally anything between the interface and code.

**Pete_UK** · 11-06-2020, 10:07 PM

A few years ago (2014) this forum launched a competition to design dashboards, and you can see the results by clicking on the Dashboards button on the upper menu at the top of the screen.

That should give you some ideas on what can be achieved.

Hope this helps.

Pete