Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
Alexandra21
 | Femeie
24 ani
Calarasi
cauta Barbat
24 - 53 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #2 |
TRaPModerator
Postari: 960
|
|
Source:
https://www.techrepublic.com/article/ho ... cel-chart/
I used the following on the table with values used to make the chart:
1. Select the data range.
2. Click the Number group's dialog launcher (Home tab). In Excel 2003, right-click the selected range and choose Format Cells.
3. In the resulting dialog box, choose Custom from the Category list.
4. In the Type field, enter 0;;;
Since I had values with no decimals I used the above: 0;;;
For numbers with decimals use: 0,0;;;
For percentages use: 0,0%;;;
For numbers with 2 decimals and thousands separator, i used: #.0,00;;;
|
|
| |
|
| #3 |
TRaPModerator
Postari: 960
|
|
|
| |
|
| #4 |
TRaPModerator
Postari: 960
|
|
Besides not showing zeroes on an Excel chart, I am today using a horizontal 100% Stacked Bar chart and want to be able to hide percentages that are smaller than 1,5% on the chart while, of course, keeping the right percentages in the cells. Doing a ROUND function would provide bad results (99%, 101%) if summing the percentages.
This is done also with a custom number format that will also include the values that are zero, but it is useful only if you have positive values. If you need negative values to be displayed, you must not use the following custom format:
[>0,015]0%;;;
Source:
https://www.excelforum.com/excel-charti ... ost3177854
|
|
| |
|
| #5 |
TRaPModerator
Postari: 960
|
|
|
| |
|
