Limitar y canviar valores

%3CLINGO-SUB%20id%3D%22lingo-sub-2672940%22%20slang%3D%22es-ES%22%3ELimit%20and%20canviate%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672940%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20afternoon%2C%20I%20have%20a%20little%20problem%20with%20my%20radio%20charts%2C%20see%20if%20you%20can%20help%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20radial%20graph%20with%20percentage%20values%20from%200%20to%2010%2C%20but%20I%20have%20values%20that%20exceed%20the%20value%2010%2C%20is%20there%20any%20way%20or%20function%20I%20can%20create%2C%20so%20that%20if%20a%20value%20exceeds%20the%20number%2010%20it%20stays%20in%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20in%20the%20graph%20the%20maximum%20value%20would%20be%2010%20and%20I%20would%20not%20get%20out%20of%20the%20graph.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2672940%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2673512%22%20slang%3D%22en-US%22%3ERe%3A%20Limitar%20y%20canviar%20valores%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2673512%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1134388%22%20target%3D%22_blank%22%3E%40Guillemfisio%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20MIN%20function%20should%20help.%20If%20you%20run%20each%20value%20through%20a%20formula%20like%20this%20(assuming%20all%20of%20the%20values%20are%20in%20column%20A%2C%20just%20copy%20this%20down%20in%20column%20B.%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DMIN(A1%2C10)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EIf%20A1%20is%20anything%20less%20than%2010%2C%20it%20will%20show%20the%20actual%20value.%20But%20if%20greater%20than%2010%2C%20it%20will%20show%2010.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Buenas tardes, tengo un pequeño problema con mis graficas radiales, aver si me pueden ayudar.

 

He creado una grafica radial con unos valores en porcentaje del 0 al 10, pero tengo valores que superan el valor 10, hay alguna manera o función que pueda crear, para que si un valor sobrepasa el número 10 se quede en él?

 

Así en la gràfica el valor máximo sería 10 y no se me saldría fuera de la gráfica.

 

Gracias

1 Reply

@Guillemfisio 

 

The MIN function should help. If you run each value through a formula like this (assuming all of the values are in column A, just copy this down in column B.

=MIN(A1,10)

If A1 is anything less than 10, it will show the actual value. But if greater than 10, it will show 10.