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