Only chart certain values

  • Thread starter Thread starter jhorsley
  • Start date Start date
J

jhorsley

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
 
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
 
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
 
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 :-)
------------------------------­------------------------------­----------------
 
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/
_______
 
Dohhh - didn't even see the reference to a Pie chart :-(

Cheers Jon

Regards
Ken............
 
Back
Top