Speedometer charts for operational availability (%)

Hello my friends, after reading you for a while and interacting with your recommendations and support for the team of followers, it is important to point out that we always have the support of you, who are a great team.
In fact, I would like to tell you that I have the following case, OPERATING AVAILABILITY (%) for warehouses A, B and C, which has three conditions: day, month and year (all averages, already established). In fact, I want to ask for your help in entering a speedometer into this job without altering the conditions (day, month and year) for warehouses A, B and C.
I appreciate your help in advance.

I attach an image of the file.

Warehouse A Warehouse B Warehouse C
DAY MONTH YEAR DAY MONTH YEAR DAY MONTH YEAR

OPERATIONAL AVAILABILITY (%) 85.02% 87.51% 90.57% 88.20% 89.98% 92.69% 81.02% 83.51% 95.90%


AVAILABILITY.xlsx

Captura de pantalla 2025-02-18 234426.jpg

Admin Note

This thread is duplicated in
https://www.excelforum.com/non-engli...ilability.html

Because this is in English and the other thread is in Spanish I'll allow the duplicate but please be aware of the rules.

Appreciate the kind words for the site.
In my opinion the charts displayed in post #1 would require a lot of explanation and therefore aren't easy to understand especially the one for warehouse b where 90.57% is larger than 88.20%.
Here is an article about speedometer charts written by a professional chart maker: https://peltiertech.com/?s=speedometer+chart
In the attached file there are three cluster column charts which are easy to produce, and I feel would be easy to understand at a glance.
Let us know if you have any questions.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
For new members: you will not be able to post a full URL, so remove the https://www. section and add one or two breaks to the rest of the address. A Moderator or Admin will then fix the link for you.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)