Pete Mccann
Member
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:
Is there a way to modify the existing Speedometer chart to include the 4th stage?
Thanks
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