Bar chart with no zero columns

M

mac

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
 
A

Andy Pope

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
 
M

mac

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top