John --

Thank you for both methods. I will try the dynamic one first.

Larry

"John Mansfield" wrote in message
...
L Mehl,

This site describes a dynamic option:


http://www.pdbook.com/index.php/exce...ied_to_zero_va
lues/

----
Regards,
John Mansfield
http://www.pdbook.com

"L Mehl" wrote:

Hello --

We have categories and category %'s totalling 100%; selected category %
values might be 0 in some data sets.

Example data set:

Category Category %
========= ==========
Magazines 5
Newspapers 20
Radio 0
TV 30
Cable 45
Satellite 0
---------
Total 100

In this case, we want vertical bars representing the Category %s for
Magazines, Newspapers, TV, and Cable, with these category names as
X-axis
labels.

What is the best way to eliminate from the chart the categories having
Category % values = 0?

Thanks for any help.

L Mehl