V
V
Vasily2017-10-23 12:48:57
excel
Vasily, 2017-10-23 12:48:57

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"@

How to add this format to word?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
shushpanio, 2017-10-23
@shushpanio

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 question

Ask a Question

731 491 924 answers to any question