Doughnut Pie chart

Hello,

I need to design a donut pie chart that shows the machine efficiency. The data to be used is 'machine efficiency tab' and want a doughnut pie chart created that shows if the overall efficiency of that machine for that contract.

0-50% red
50-80% Orange
80-100% green


Example of a doughnut chart is shown in the tab 'machine efficiency'.

The chart needs to be created in the tab 'Sheet1'. Once created, when the contract is selected from the drop down list B5, it should automatically update the doughnut chart for that contract.

I've tried something here.

I assumed that Core Hours were the functioning machine hours and Total Hours were the time it should be working (for the percentage of uptime for each contract).

In cell B8 you have the percentage of uptime.

For the graphics, you wanted a gauge chart right? It was nice to learn how to do one.

Follows attachment.

Regardstest (2).xlsx

Hello,

Thank you for this.. can you explain what the test data is for? and how it works?