Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |