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


--
jhorsley
------------------------------------------------------------------------
jhorsley's Profile: http://www.excelforum.com/member.php...o&userid=26040
View this thread: http://www.excelforum.com/showthread...hreadid=480868

Only chart certain values
 

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(B50,B5," ") and if any number = 0, it wont be calculated into you
pie chart

Cheers


Thiem


--
Thiem
------------------------------------------------------------------------
Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=480868

Only chart certain values
 

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(B50,B5," ") and if any number = 0, it wont be calculated into you
pie chart

Cheers


Thiem


--
Thiem
------------------------------------------------------------------------
Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=480868

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" wrote in
message ...

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

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.

Only chart certain values
 

Dohhh - didn't even see the reference to a Pie chart :-(

Cheers Jon

Regards
Ken............

"Jon Peltier" wrote in message
...
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.