Bar chart with no zero columns

[Guest]

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

 

[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

 

[Guest]

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

 

[Andy Pope]

Why do you not want to use filtering? You could always place your chart data
somewhere else within the workbook if it effects your presentation.

Maybe with formula you could modify this technique.
http://www.cellmatrix.net/index.php/site/comments/pie_chart_exclude_zero_values/

Cheers
Andy

 

[Guest]

As a follow-up, here's a link to a modification of the formulas:

http://www.cellmatrix.net/index.php/bar_chart_exclude_zero_values

--
John Mansfield
http://cellmatrix.net