Designing dashboards (donut pie charts)

Hello

I need to create a doughnut pie chart dashboard that shows how efficient machine is within each area. The information would need to be picked up from the efficient report.

One contract can have many machines so it would need to calculate all machines in that area and then show the overall efficiency.

The formula needs to be working in the 'test' spreadsheet. You may need v-lookups or index.

When the contract is selected from the drop down list box, it should automatically provide the machine efficiency for that one contract.

Can anyone support me on this?

I can attach the document files after.

In order to try and help you would need to attach a copy of your file.

peterrc