• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Speedometer Chart with 4 sectors

Hi Chandoo colleagues. For some time now we’ve been using a 3-sector Speedometer chart in our monthly presentations to management (please see attached spreadsheet). The three sectors each represent progress (between 0% and 100%) of unrelated stages of a larger process. This works well.

Management have asked if we can now include an additional stage to this Speedometer chart (4 stages in total). Each stage still represents progress (between 0% and 100%) and the stages are still not related. The attached spreadsheet shows an example of what we'd like to do.

It would be good if we could keep the fairly simple data entry table:
Total​
no. complete​
% Label​
Stage 1​
700​
615​
88%​
Stage 2​
983​
800​
81%​
Stage 3​
650​
603​
93%​
Stage 4​
1000​
800​
80%​

Is there a way to modify the existing Speedometer chart to include the 4th stage?

Thanks
 

Attachments

Top