Hello
Is there a way to elminate zero percent from showing in a pie chart?
!https://skitch.com/jwillua/fw8pm/screen-shot-2011-08-26-at-11.32.13-pm!
There are rows between a set a values and the footer, the chart zero percent for the rows with no value..
!https://skitch.com/jwillua/fw8pp/screen-shot-2011-08-26-at-11.34.16-pm!
Select only the four cells that contain values?
Regards,
Barry
yeah, obv., but i would like to keep the chart so data can be entered in the blank cells and the chart will update and wont have to be edited every time. Some people using it wont even know how to edit the chart even if they wanted to.
I made a pie chart of what you showed and I have no 0% on the chart. It charted the four data points and the value in the footer. Only by putting a small number in one of the "empty" cells was I able to get a 0%.
Do you have a hidden row or have you formatted a cell in a way that you are not seeing one of the data points in your table?
No, i checked, the empty cells i have contain nothing at all. Are your empty cells still designated as being part of the graph data, like pictured below? Thanks..
The only way I was able to get the 0% displayed was this one :
I charted the entire column C but I defined a conditional format to cells C3 thru C18.
Values smaller than 0.0002 are displayed with ink 'none', a scheme with I already saw in use to hide small values resulting from the IEEE behavior
and of course one of the cells which seems to be empty contain the value 0.00001
Yvan KOENIG (VALLAURIS, France) samedi 27 août 2011 22:15:33
iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0
My iDisk is : <http://public.me.com/koenigyvan>
Please : Search for questions similar to your own before submitting them to the community
To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !
i have checked many times, the empty cells are empty in all columns and rows with no conditional formatting or anything applied, truly empty cells and yet I still get a 0%.
In this case, here is the last resort answer: send the charted table to my mailbox so I would be able to search, not guess.
Click my blue name to get my address.
For me it's time to switch off.
Will be back tomorrow.
Yvan KOENIG (VALLAURIS, France) samedi 27 août 2011 22:37:04
iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0
My iDisk is : <http://public.me.com/koenigyvan>
Please : Search for questions similar to your own before submitting them to the community
To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !
I also made one (a pair, actually), using different data and skipping some cells in the column. I also diid not include a total (which, if included in the graph, should show as 50%).
Chart 1 uses the selected data in column B. This is directly entered from the keyboard, and 'blank' cells actually contain no data.
Chart 2 uses the calculated data in column C, produced by the formula:
=IF(LEN(B)>0,B,"")
Any data written into Column B, including the text in row 6 and the zero in row 7, is copied into Column C. Cells that appear 'blank' in this column actually contain a null string—a text string of length zero.
Zero per cent is not displayed in either case.
Regards,
Barry
Barry, Yvan, i emailed you both a simple version of my problem, please see it and tell me what you think. Thanks guys.
Hi J,
After a little playing with the chart, it appears that the 0% shows when you also have 'Show Series Names' checked. In the example, I've filled in the empty Holdings cells with the letters A to J so the series names will be visible:
Looks like the Series name and the value occupy the same 'box'. If you choose to show both, then the names (even if they're blank or null strings) will take display space and will force the zero values to display as well.
I don't think it's a user-changeable feature.
Regards,
Barry
Barry,
I'm still unable to get a 0%. I'm charting the exact data given in the original post (though I left off the decimals). The only way I get a 0% is if I put a small non-zero number in one of the blank cells. By the color it would appear to be in the row three rows below 54.78.
What I see on your chart is a bunch of label letters overlaid on each other, which would happen if they were all 0% and contiguous in the table.
thanks for the help guys, i believe Yvan is going to submit this as a bug. Seems that a line with no data and a blank label should be plotted for any reason...
Badunit: here a link to a sample of the file if you want to see what's goin on.. Thanks http://tinyurl.com/3cwlrme
Hi Badunit
It seems that you missed the late message posted by Barry.
We get the zero percent when we check the box "Show Series Name".
Yvan KOENIG (VALLAURIS, France) dimanche 28 août 2011 21:54:30
iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0
My iDisk is : <http://public.me.com/koenigyvan>
Please : Search for questions similar to your own before submitting them to the community
The report is filed as
Bug ID# 10036134. |
Summary:
Numbers charts display unwanted zero values
Steps to Reproduce:
Open a Numbers document with a table containing values like these ones :
one header row with 1000 in cell B1
cell C2 contains 131.28
cell C3 contains 60.62
cell C4 contains 28.25
cell C5 contains 54.78
cells C6 thru C15 remain blank
one footer row with the formula =$B$1-SUM(C) [result 725.07]
Build a Pie Chart from these values
Expected Results:
See percentage values for non empty cells
Actual Results:
As long as we don’t ask to display the series names, it’s OK
If we ask to display series names, we get the series names and value 0% displayed for every empty cell.
If there are no serie name defined for blank cells, we get no serie name but we get the 0% values displayed (superposed).
Regression:
None except drop the "Show series names" feature
Notes:
This behavior seems to be inconsistent.
As numerical values 0 aren’t displayed when we don’t display series names,
it seems inconsistent to display them when we ask the app to display the series names.
In cell A10 of the table "with labels A6 thru A15" I deliberately used the name "A 10" to show that series names are stacked.
The sample file is attached
I don't attach a screenshot here because, at this time, the techies driving these forums are unable to repair the oddity preventing me to insert pictures from Lion ! Maybe I will open my own rant thread to complain about that 😉
Yvan KOENIG (VALLAURIS, France) dimanche 28 août 2011 22:08:00
iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0
My iDisk is : <http://public.me.com/koenigyvan>
Please : Search for questions similar to your own before submitting them to the community
graph to not show zero percent??
