If you read my question, I said I dont want to use filtering. Thanx anyway.
Do you have any other ideas.

"Andy Pope" wrote:

Hi,

You could use filtering to hide the rows. Make sure the chart has Plot
visible cells only set.
Select the chart and check via Tools Options Chart Plot visible cells
only

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"mac" wrote in message
...
I have a colums with a hundreds a values and only twenty is real values the
rest is all zero. How do I plot a bar chart showing only the values and
omits
the zero values from the chart. My chart is plotting all zero values which
makes it impossible to view. Is there a way of not plotting the zero
columns
without filtering the data. I read the previous posts but the NA() allso
shows zero values. Any help would be appreciated. Thanks