Bar chart with no zero columns
 

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

Bar chart with no zero columns
 

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

Bar chart with no zero columns
 

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

Bar chart with no zero columns
 

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/...e_zero_values/

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"mac" wrote in message
...
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

Bar chart with no zero columns
 

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

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

--
John Mansfield
http://cellmatrix.net





"Andy Pope" wrote:

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/...e_zero_values/

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"mac" wrote in message
...
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