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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Larina23
 | Femeie
23 ani
Timis
cauta Barbat
28 - 80 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
Source:
Use a custom number format that doesn't show zeros, for example, one of these:
If your decimal separator is . (point):
$0.00;($.00);;@
0.00%;-0.00%;;@
0;0;;@
If your decimal separator is , (comma):
$0,00;($,00);;@
0,00%;-0,00%;;@
0;0;;@
Source:
If you want to display thousands separator you can use the following format:
#.###;-#.###,;;@
|
|
| pus acum 7 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Source:
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;;;
Modificat de TRaP (acum 5 ani)
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Don't display decimals in table (raw data for charts):
|
|
| pus acum 1 an |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
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:
|
|
| pus acum 7 luni |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
A nice chart design to display positive and negative trends:
|
|
| pus acum 7 luni |
|