How to ignore negative numbers for pie chart?

[Bill Koran]

Using Excel 97
I am charting a data series from a pivot table. This data series indicates
how much each item is contributing to a problem. The last few items are
negative, indicating that those items are helping to correct the problem.
It seems that, for pie charts, Excel takes the absolute value and includes
these last few items on the pie.

Example Series
33.3 11.1 22.2 -33.3

Thie pie chart of this shows up with 2 slices of 33%, 1 slice of 11%, and 1
slice of 22%. How can I make this show up as just 3 slices, igoring
negative numbers?

I checked Deja News, and a search using all keywords, with keywords of
"pie" and "negative" came up empty. Other found items didn't address this,
either.

TIA
Bill Koran, P.E.
Energy Conservation Engineer

[Earl Kiosterud]

Bill;

Here's one way:

set up another column (or row) and use =if( value<0, 0, value). This will
convert your negative values to 0, which will cause a slice of size 0,
though you'll still see labels for these points, if your chart is using
them. If there are two negative values, the labels will pile up at the same
point.

--
Regards from Virginia Beach, VA

Earl Kiosterud
ea...@livenet.net
-------------------------------------------------------------

Bill Koran <bko...@aol.com> wrote in article
<01be10c9$91a91200$4885aa98@HB021747_Bkoran.honeywell.com>...

[Bill Koran]

Earl, thanks for the feedback. I tried that, and looked for an option to
not plot zero values, but didn't see such an option for a pie chart. I am
using labels, and I have 3 negative values, so it isn't too attractive.
For temporary purposes, I sorted and just plotted the positive values, but
I don't want to have to do that in the future. If you have any other
ideas, I would like to hear them.

Thanks,
Bill

Earl Kiosterud <ea...@livenet.net> wrote in article
<01be12a8$e4ae81c0$9e1f9cce@earlp200>...

[Steve Kunnmann]

Bill,

You could create a macro that would do the sorting adn then
range selection for you. Still doesn;t "fix" the problem, but
would make your temp. fix easier.

Steve

On Tue, 17 Nov 1998 23:09:01 -0800, "Bill Koran" <bko...@aol.com>
wrote: