Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Zero Values on a Pie Chart
Hi Everyone! I am doing a pie chart and I can't seem to get the chart to NOT
display "zero" values on the pie. I have tried everything and still cannot get it to not display it. I went to 'Tools' then 'Options' then to 'Chart', where it says "Plot empty cells as:" it is gray and I am not able to select anything. It has already pre-selected "Not plotted (leave gaps)". I don't know if this is why it keeps showing them on the pie or not? The "Plot visible cells only" is checked. Can anyone help me? Also is there a way to to get Excel to do a pie if I have 12 columns across (all months) and 15 rows (list of expenses)? I have been trying to get it to give me a pie for all 12 months with all expenses as averages, but it keeps giving me only 1 month at a time. Is it not possible to have it give me an accumulation of all 12 months? Thank you to anyone who can help... |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Zero Values on a Pie Chart
Hi Everyone! I am doing a pie chart and I can't seem to get the chart to
NOT display "zero" values on the pie. I have tried everything and still cannot get it to not display it. I went to 'Tools' then 'Options' then to 'Chart', where it says "Plot empty cells as:" it is gray and I am not able to select anything. It has already pre-selected "Not plotted (leave gaps)". I don't know if this is why it keeps showing them on the pie or not? The "Plot visible cells only" is checked. Can anyone help me? Plot Empty Cells As is really only valid for line and XY charts, and the Empty Cells have to be truly empty, not zero and not a formula that looks empty. If you use a bar chart (see below), you can show a zero next to its label, and without the confusion of a pie chart with a zero wedge, the reader can tell that the category has a zero value. Also is there a way to to get Excel to do a pie if I have 12 columns across (all months) and 15 rows (list of expenses)? I have been trying to get it to give me a pie for all 12 months with all expenses as averages, but it keeps giving me only 1 month at a time. Is it not possible to have it give me an accumulation of all 12 months? If you want to show a sum, you need to perform the sum in the worksheet, and plot the cells with the sums. 15 values is a lot to put into a pie chart. Pies work best with a max of three to five items. It might be better to use a bar chart. Sort the data first, so the data is plotted largest to smallest. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Zero Values on a Pie Chart
Thank you so much that answers my questions. Don't you think Microsoft Excel
would be updated enough in this day and age to be able to just give a command for the whole worksheet where a person could tell it to not show zero values at all on whatever type of chart a person was doing? I've read some of these post and it seems it is a lot of work to make it happen even on the other charts where it is possible... "Jon Peltier" wrote: Hi Everyone! I am doing a pie chart and I can't seem to get the chart to NOT display "zero" values on the pie. I have tried everything and still cannot get it to not display it. I went to 'Tools' then 'Options' then to 'Chart', where it says "Plot empty cells as:" it is gray and I am not able to select anything. It has already pre-selected "Not plotted (leave gaps)". I don't know if this is why it keeps showing them on the pie or not? The "Plot visible cells only" is checked. Can anyone help me? Plot Empty Cells As is really only valid for line and XY charts, and the Empty Cells have to be truly empty, not zero and not a formula that looks empty. If you use a bar chart (see below), you can show a zero next to its label, and without the confusion of a pie chart with a zero wedge, the reader can tell that the category has a zero value. Also is there a way to to get Excel to do a pie if I have 12 columns across (all months) and 15 rows (list of expenses)? I have been trying to get it to give me a pie for all 12 months with all expenses as averages, but it keeps giving me only 1 month at a time. Is it not possible to have it give me an accumulation of all 12 months? If you want to show a sum, you need to perform the sum in the worksheet, and plot the cells with the sums. 15 values is a lot to put into a pie chart. Pies work best with a max of three to five items. It might be better to use a bar chart. Sort the data first, so the data is plotted largest to smallest. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Only chart numerical values, not error values | Charts and Charting in Excel | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
Troubles with asigning x values and values to a chart | Excel Discussion (Misc queries) | |||
Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel | |||
Can I obtain x values from y values on an Excel chart? | Charts and Charting in Excel |