Answer the question
In order to leave comments, you need to log in
How to create an Excel number format with replacing numbers with text?
I'm creating a radar chart in word 2016. In order to set the axis format values I need, I need to create my own number format that would change the numbers in the specified range to characters, and display this on the chart axis, but for some reason I get the error: Application Microsoft Excel cannot apply the entered number format. Here is my format:
[Красный][<=10]#,0 "A1"@[Желтый][<=30]#,0 "A2"@[Желтый][<=40]#,0 "B1"@[Синий][<=60]#,0 "B2"@[Зеленый][<=70]#,0 "C1"@[Зеленый][>70]#,0 "C2"@
Answer the question
In order to leave comments, you need to log in
Excel stores number formats like this:
Format Negative Values; Format for 0; Format of positive values.
those. Side1;Block2;Block3, and you have Side1;Block2;Block3; Side4;Block5;Block6 is the reason for the
UPD error: More correctly:
<POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT>
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question