 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
11-01-2005, 02:19 PM
|
|||
|
|||
|
Only chart certain values
I'm trying to chart some data into a pie chart automatically once a moth or so. I just want to add the data and have the chart chart itself. The problem is that some of the data can come in with a zero value one month and other months a value above 0. For the months that it comes in as zero I don't want the chart to graph it.
Is there a way to do this? Thanks jhorsley 
|
|
#2
11-02-2005, 11:09 AM
|
|||
|
|||
|
Yes there is, however this will be a simple IF fuction
Say you chart info cells is B5:B10 Use the following in cell C5:C10 and use cells C5:C10 as your new data range =IF(B5>0,B5," ") and if any number = 0, it wont be calculated into you pie chart Cheers Thiem
|
|
#3
11-02-2005, 11:10 AM
|
|||
|
|||
|
Yes there is, however this will be a simple IF fuction
Say you chart info cells is B5:B10 Use the following formula in cell C5:C10 and use cells C5:C10 as your new data range =IF(B5>0,B5," ") and if any number = 0, it wont be calculated into you pie chart Cheers Thiem
|
|
#4
11-02-2005, 06:17 PM
|
|||
|
|||
|
Re: Only chart certain values
Have the data you are pulling from be the result of formulas such as
=IF(xyz=0,NA(),xyz) This means that in place of 0 you will have N/A and that will not be plotted on the chart (Unless it is one specific type which will still show it - Can't remember which). Assume it's a line chart or something similar and you just don't want the line dropping to the axis for the missing data. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "jhorsley" <jhorsley.1xu3qi_1130875821.1594@excelforum-nospam.com> wrote in message news:jhorsley.1xu3qi_1130875821.1594@excelforum-nospam.com... > > I'm trying to chart some data into a pie chart automatically once a moth > or so. I just want to add the data and have the chart chart itself. > The problem is that some of the data can come in with a zero value one > month and other months a value above 0. For the months that it comes > in as zero I don't want the chart to graph it. > > Is there a way to do this? > > Thanks > > jhorsley > > > -- > jhorsley > ------------------------------------------------------------------------ > jhorsley's Profile: > http://www.excelforum.com/member.php...o&userid=26040 > View this thread: http://www.excelforum.com/showthread...hreadid=480868 >
|
|
#5
11-02-2005, 06:50 PM
|
|||
|
|||
|
Re: Only chart certain values
The problem with a zero is not that the wedge will show; it won't. The
problem is that a data label will show. Both suggestions so far, using IF to replace zero with NA() or with "" still leave an unwanted label, which either shows 0 or #N/A. Andy Pope shows a dynamic range technique to omit these zeros on his web site: http://andypope.info/charts/piezeros.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Ken Wright wrote: > Have the data you are pulling from be the result of formulas such as > =IF(xyz=0,NA(),xyz) > > This means that in place of 0 you will have N/A and that will not be plotted > on the chart (Unless it is one specific type which will still show it - > Can't remember which). > > Assume it's a line chart or something similar and you just don't want the > line dropping to the axis for the missing data. >
|
|
#6
11-04-2005, 12:50 PM
|
|||
|
|||
|
Re: Only chart certain values
Dohhh - didn't even see the reference to a Pie chart :-(
Cheers Jon Regards Ken............ "Jon Peltier" <jonREMOVExlmvp@peltierCAPStech.com> wrote in message news:%234EzU9$3FHA.3292@tk2msftngp13.phx.gbl... > The problem with a zero is not that the wedge will show; it won't. The > problem is that a data label will show. Both suggestions so far, using IF > to replace zero with NA() or with "" still leave an unwanted label, which > either shows 0 or #N/A. > > Andy Pope shows a dynamic range technique to omit these zeros on his web > site: > > http://andypope.info/charts/piezeros.htm > > - Jon > ------- > Jon Peltier, Microsoft Excel MVP > Peltier Technical Services > Tutorials and Custom Solutions > http://PeltierTech.com/ > _______ > > > Ken Wright wrote: > >> Have the data you are pulling from be the result of formulas such as >> =IF(xyz=0,NA(),xyz) >> >> This means that in place of 0 you will have N/A and that will not be >> plotted on the chart (Unless it is one specific type which will still >> show it - Can't remember which). >> >> Assume it's a line chart or something similar and you just don't want the >> line dropping to the axis for the missing data. >>
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
