Skip i'r prif gynnwys

Sut i guddio labeli data sero yn y siart yn Excel?

Weithiau, gallwch ychwanegu labeli data yn y siart ar gyfer gwneud gwerth y data yn gliriach ac yn uniongyrchol yn Excel. Ond mewn rhai achosion, mae sero labeli data yn y siart, ac efallai yr hoffech chi guddio'r labeli data sero hyn. Yma, dywedaf wrthych ffordd gyflym o guddio'r labeli data sero yn Excel ar unwaith.

Cuddio labeli data sero yn y siart


swigen dde glas saeth Cuddio labeli data sero yn y siart

Os ydych chi am guddio labeli data sero yn y siart, gwnewch fel a ganlyn:

1. Cliciwch ar y dde yn un o'r labeli data, a dewiswch Labeli Data Fformat o'r ddewislen cyd-destun. Gweler y screenshot:

doc-cuddio-sero-data-label-1

2. Yn y Labeli Data Fformat deialog, Cliciwch Nifer yn y cwarel chwith, yna dewiswch Custom o'r Categori blwch rhestr, a theipiwch # "" i mewn i'r Cod Fformat blwch testun, a chlicio Ychwanegu botwm i'w ychwanegu ato math blwch rhestr. Gweler y screenshot:

doc-cuddio-sero-data-label-2

3. Cliciwch Cau botwm i gau'r ymgom. Yna gallwch weld bod yr holl labeli data sero wedi'u cuddio.

doc-cuddio-sero-data-label-3

Tip: Os ydych chi am ddangos y labeli data sero, ewch yn ôl i ymgom Labeli Data Fformat, a chlicio Nifer > Custom, a dethol #, ## 0; - #, ## 0 yn y math blwch rhestr.

Nodyn: Yn Excel 2013, gallwch glicio ar y dde ar unrhyw label data a dewis Labeli Data Fformat i agor y Labeli Data Fformat cwarel; yna cliciwch Nifer i ehangu ei opsiwn; cliciwch nesaf ar y Categori blwch a dewis y Custom o'r gwymplen, a theipiwch # "" i mewn i'r Cod Fformat blwch testun, a chliciwch ar y Ychwanegu botwm.

doc-cuddio-sero-data-label-4


Erthyglau Perthynas:

Offer Cynhyrchiant Swyddfa Gorau

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 Gorau12 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...

tab kte 201905


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 (15)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Muito obrigado!
This comment was minimized by the moderator on the site
Depending on your data set, you could use a helper column. The formula could use rounddown or IF(cell<1,0,cell). This way your slicers stay intact and your pie chart uses the new column.
This comment was minimized by the moderator on the site
I have a pivot chart (pie chart) where I need to remove the labels for any slice of the pie with a value under 1%. Right now, these are displayed as 0% (no decimal places). I am also using slicers to analyse the data by month, department and person. I am trying to get the chart to hide any labels where the value is less than 1%, but this will change when I change the variables in the slicers. I have fallen down a rabbit-hole here trying to figure this out.
This comment was minimized by the moderator on the site
The Microsoft way of doing it (though not found on ana MS help page) is to click File>Options>Advanced, scroll down to 'Display options for this worksheet', and uncheck / untick 'Show a zero in cells that have a zero value'. All the zeros disappear.

I seem to have found a way to remove the axis name and space on a graph or chart for zero values: Highlight the whole table, click Home>Sort and filter>Filter, Click on the header of the column with the blank zero values, and uncheck / untick 'Blanks'.
This comment was minimized by the moderator on the site
Thanks that really works well for me.
This comment was minimized by the moderator on the site
tnx, it works
This comment was minimized by the moderator on the site
How can I hide Zero Data Labels when it is percentage (for example 0,00%, I do not want that label to be shown)?
This comment was minimized by the moderator on the site
<span style="letter-spacing: 0.2px; color: inherit; font-family: inherit; font-style: inherit; font-variant-ligatures: inherit; font-variant-caps: inherit; font-weight: inherit;">0.0%;-0.0%;""    </span>
This comment was minimized by the moderator on the site
Hi
Thank you for sharing the solution above. It was really great help. However, after hiding zero values, I am having difficulties with hiding their labels. Can you please give a solution for that problem, too? Thank in advance for your help.
This comment was minimized by the moderator on the site
Found this solution absolutely useful. Thanks a ton.
This comment was minimized by the moderator on the site
Great solution! Can this be done retaining decimal points on the numbers that do appear?
This comment was minimized by the moderator on the site
Kelcey, use: #,##"";-#,##""; When using the second semicolon, you define what happens in case of zero. So, if you don't define anything, the value stays blank.
This comment was minimized by the moderator on the site
I use 0.0;;; and it also does the trick, in terms of retaining decimal places. You'd just adjust to the # of sig figs you want to keep. You have to assign the custom value to each data label series, but it keeps that format each time you refresh the data.
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations