LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Only chart numerical values, not error values andy Charts and Charting in Excel 2 November 8th 07 10:46 PM
chart from pivot data does not update x-axis bar chart values - bug jason gers Excel Discussion (Misc queries) 0 April 3rd 07 06:34 PM
Troubles with asigning x values and values to a chart [email protected] Excel Discussion (Misc queries) 0 July 31st 06 04:15 PM
Huge differences in chart values screws my bar chart scale up. Sirritys Charts and Charting in Excel 2 June 13th 06 10:33 AM
Can I obtain x values from y values on an Excel chart? Helen Charts and Charting in Excel 1 March 7th 06 03:05 PM


All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"