|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 9th, 2006, 05:25 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Not Displaying Zero Values
Hello, I have a pie chart being created based on the value of a series of
rows. Since some of the cells within these rows are zero, I would like the chart to populate based on the values that are greater than zero. I thought I could address it by writing a formula to only show a value, if the result was greater than zero, but to no avail. The ultimate goal, to make the chart less-busy, is to only have the chart populate on numbers greater then zero. Can anyone help with this? Any and All Help Will Be Appreciated - Thanks In Advance 
|
|
#2
February 10th, 2006, 10:17 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Not Displaying Zero Values
Hi,
I have one method explained here, http://www.andypope.info/charts/piezeros.htm Cheers Andy MWS wrote: Hello, I have a pie chart being created based on the value of a series of rows. Since some of the cells within these rows are zero, I would like the chart to populate based on the values that are greater than zero. I thought I could address it by writing a formula to only show a value, if the result was greater than zero, but to no avail. The ultimate goal, to make the chart less-busy, is to only have the chart populate on numbers greater then zero. Can anyone help with this? Any and All Help Will Be Appreciated - Thanks In Advance -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Combine FREQUENCY and SUM of Associated Values | MichaelC | Worksheet Functions | 3 | July 3rd, 2005 01:54 AM |
| Displaying values from zero on graph | Marc | General Discussion | 0 | April 14th, 2005 09:21 PM |
| Automatically displaying values on a Form | Larry | Using Forms | 2 | April 4th, 2005 02:05 PM |
| Combo box returns numeric values | Joe | Running & Setting Up Queries | 5 | December 1st, 2004 03:03 PM |
| Cell values not displaying | Alan | Worksheet Functions | 1 | January 20th, 2004 02:42 PM |
Linear Mode
