Excel Dashboard Creation & Data Display

Description

Hi,
I have a number of projects that I would like a excel specialist to look into.I have a client that is particularly keen in having a pictorial dashboard to display information that's held within our documents we produce on their behalf.
In the short term this initial project is just to create a visual representation of the following key pieces of data that are included within a report. Qty Assets = each row Qty Failed Assets = Colum GQty Passed Assets = Colum GQty CRITICAL Faults = Colom YQty MAJOR Faults = Colum YThese values are obtained using the round hill register tab(2nd tab Improved data required excel attached)You will see that currently; I've produced a pie chart that does not display the information correctly.Please see attached that shows a crude drawing of how I would like the information to be displayed.Once I have this template completed, we rasie a separate future project to populate a dashboard using such info as • No of inspections completed this year • No of site completed this month• Total number of pass and fails for each site• Defect grades of each site• Total number of repairs this month• Total number of assets inspected each monthI would like this info to be available to display info using another tracking style excel document that we can use to display info regarding the project as a whole.I look forward to hearing from you.Thanks,Paul.