How to create a percentage gauge in excel
Solved
ghnacer
Posted messages
44
Status
Membre
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Hello everyone
I found a template on Excel, and it's really what I wanted to do with my own file! But I don't understand how they built the file.
I'm attaching the Excel file here: https://www.cjoint.com/c/HAjpAcIFyYK
If you look at the home tab, they created this % gauge based on the information found in the "movement information" tab.
Does anyone have any tips please?
Thank you all
Have a good evening :)
Configuration: Windows / Chrome 63.0.3239.132
I found a template on Excel, and it's really what I wanted to do with my own file! But I don't understand how they built the file.
I'm attaching the Excel file here: https://www.cjoint.com/c/HAjpAcIFyYK
If you look at the home tab, they created this % gauge based on the information found in the "movement information" tab.
Does anyone have any tips please?
Thank you all
Have a good evening :)
Configuration: Windows / Chrome 63.0.3239.132
2 réponses
Hello
in this model
place the cursor in cell G33
to do the same:
best regards
--
The quality of the response primarily depends on the clarity of the question, thank you!
in this model
place the cursor in cell G33
- go to the conditional formatting icon / manage rules and see the "data bar" option which displays in white the part of the cell corresponding to the calculated %
to do the same:
- select the necessary cell
- conditional formatting
- and in the displayed menu: "data bar"
best regards
--
The quality of the response primarily depends on the clarity of the question, thank you!