Skip i'r prif gynnwys

Sut i fformatio labeli echelin fel miloedd / miliynau yn Excel?

Os oes gennych siart yn Excel fel y dangosir isod, a nawr rydych chi am fformatio'r labeli echelin fel miloedd / miliynau fel 100K, 1M, sut allwch chi ei ddatrys?

doc-echel-fel-mil-1

Labeli echel fformat fel miloedd / miliynau

swigen dde glas saeth Labeli echel fformat fel miloedd / miliynau

Gallwch fynd i'r ymgom Fformat Echel i fformatio'r echel.

1. Cliciwch ar y dde ar yr echel rydych chi am fformatio ei labeli fel miloedd / miliynau, dewiswch Echel Fformat yn y ddewislen cyd-destun.

doc-echel-fel-mil-2

2. Yn y Echel Fformat dialog / cwarel, cliciwch Rhif tab, yna yn y Categori blwch rhestr, dewiswch Custom, a theipiwch [> 999999] # ,, "M"; #, "K" i mewn i Cod Fformat blwch testun, a chlicio Ychwanegu botwm i'w ychwanegu ato math rhestr. Gweler y screenshot:

doc-echel-fel-mil-3

3. Deialog agos, nawr gallwch weld bod y labeli echelin yn cael eu fformatio fel miloedd neu filiynau.

doc-echel-fel-mil-4

Tip: Os ydych chi am fformatio'r labeli echelin yn filoedd neu filiynau yn unig, gallwch deipio #, "K" or #, "M" i mewn i Cod Fformat blwch testun a'i ychwanegu.

Erthyglau Perthynas:

Offer Cynhyrchiant Swyddfa Gorau

🤖 Kutools AI Aide: Chwyldro dadansoddi data yn seiliedig ar: Cyflawniad Deallus   |  Cynhyrchu Cod  |  Creu Fformiwlâu Personol  |  Dadansoddi Data a Chynhyrchu Siartiau  |  Invoke Swyddogaethau Kutools...
Nodweddion Poblogaidd: Darganfod, Amlygu neu Adnabod Dyblygiadau   |  Dileu Rhesi Gwag   |  Cyfuno Colofnau neu Gelloedd heb Colli Data   |   Rownd heb Fformiwla ...
Super-edrych: VLookup Meini Prawf Lluosog  |   VLookup Gwerth Lluosog  |   VLookup Ar Draws Taflenni Lluosog   |   Edrych Niwlog ....
Rhestr gwympo Uwch: Creu Rhestr Gollwng yn Gyflym   |  Rhestr Gollwng Dibynnol   |  Rhestr Gollwng Aml-ddewis ....
Rheolwr Colofn: Ychwanegu Nifer Penodol o Golofnau  |  Symud Colofnau  |  Toglo Statws Gwelededd Colofnau Cudd  |  Cymharwch Ystodau a Cholofnau ...
Nodweddion dan Sylw: Ffocws ar y Grid   |  Golwg Dylunio   |   Bar Fformiwla Mawr   |  Rheolwr Llyfr Gwaith a Thaflen   |  Llyfrgell Adnoddau (Testun Auto)   |  Dewiswr Dyddiad   |  Cyfuno Taflenni Gwaith   |  Amgryptio/Dadgryptio Celloedd   |  Anfon E-byst trwy Restr   |  Hidlo Super   |   Hidlo Arbennig (hidlo mewn print trwm/italig/strikethrough...) ...
15 Set Offer Gorau:  12 Testun offer (Ychwanegu Testun, Dileu Cymeriadau,...)   |   50 + Siart Mathau (Siart Gantt,...)   |   40+ Ymarferol Fformiwlâu (Cyfrifwch oedran yn seiliedig ar ben-blwydd,...)   |   19 mewnosod offer (Mewnosod Cod QR, Mewnosod Llun o'r Llwybr,...)   |   12 Trosi offer (Rhifau i Eiriau, Trosi arian cyfred,...)   |   7 Uno a Hollti offer (Rhesi Cyfuno Uwch, Celloedd Hollt,...)   |   ... a mwy

Supercharge Eich Sgiliau Excel gyda Kutools ar gyfer Excel, a Phrofiad Effeithlonrwydd Fel Erioed Erioed. Kutools ar gyfer Excel Yn Cynnig Dros 300 o Nodweddion Uwch i Hybu Cynhyrchiant ac Arbed Amser.  Cliciwch Yma i Gael Y Nodwedd Sydd Ei Angen Y Mwyaf...

Disgrifiad

Mae Office Tab yn dod â rhyngwyneb Tabbed i Office, ac yn Gwneud Eich Gwaith yn Haws o lawer

  • Galluogi golygu a darllen tabbed yn Word, Excel, PowerPoint, Cyhoeddwr, Mynediad, Visio a Phrosiect.
  • Agor a chreu dogfennau lluosog mewn tabiau newydd o'r un ffenestr, yn hytrach nag mewn ffenestri newydd.
  • Yn cynyddu eich cynhyrchiant 50%, ac yn lleihau cannoedd o gliciau llygoden i chi bob dydd!
Comments (31)
No ratings yet. Be the first to rate!
Jack
Jack
This comment was minimized by the moderator on the site
The k on the x axis is annoying. I fixed this one time, but do not have access to the device anymore. Can anyone format it so that it is 0 on the x and y intercept??
Reply
0
0
darius
darius
This comment was minimized by the moderator on the site
if ai have number 76960 and i want to display 77 K
what i must to do?
the ir no problem in table 0 "K" and it work, but it don't work in chart label
Reply
0
0
Елена
Елена
This comment was minimized by the moderator on the site
Подскажите, а если у меня число 35 387 тысяч,мне нужно чтобы на графике выглядело как 35,3К
Reply
0
0
Thangavelu
Thangavelu
This comment was minimized by the moderator on the site
How to remove particular lable in x axis using number format code?
Reply
0
0
Robert Powell
Robert Powell
This comment was minimized by the moderator on the site
Thanks for this! It worked almost perfectly. I was seeing values of 36 as "K" with no "0" preceding the K. If you want to show "0M" or "0K" this worked for me: [>999999] #0,,"M";#0,"K"
Reply
0
0
Anura Upasanta-Kumara
Anura Upasanta-Kumara
This comment was minimized by the moderator on the site
Could you kindly let me know how to feed "a thousand marks with commas" in the axis? e.g. there are values 1000, 5000, 10000, 15000...... I was asked to include commas to thousand marks. It means no commas for 1000, and 2000, but commas for 10000 as 10,000 and 15,000. I can't find a function for that. Kindly help me...Thanks
Reply
0
0
Sunny
Sunny     Anura Upasanta-Kumara
This comment was minimized by the moderator on the site
Sorry Anura, I cannot find the solution to only add commas to number that bigger than 10000, such as 10,000, to use #,##0;-#,##0 will add thousand commas to all thousand numbr, please see the screenshot:
https://www.extendoffice.com/images/stories/comments/sun-comment/doc-thousand-comma.png
Reply
Report
0
0
Elham
Elham
This comment was minimized by the moderator on the site
greats
thanks
Reply
0
0
Jill
Jill
This comment was minimized by the moderator on the site
Thanks so much, quick and easy to copy over and works a treat!!
Reply
0
0
Aarik
Aarik
This comment was minimized by the moderator on the site
In case it helps anyone else, including the second comma doesn't work for me, I have to only have one prior to the "M" designation.
Reply
0
0
Karan
Karan
This comment was minimized by the moderator on the site
Thanks a lot, it helps, brillaint
Reply
0
0
There are no comments posted here yet
Load More
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations