Hide particular Bar from bar chart

Hi,
I have bar chart with 1 series on it.
it shows 12 bars on chart.
Now, i want don't want plot one bar for particular value.
I tried with 'if' condition in value axis expression, it does show null for that related bar...but its space is still there saying null on x-axis.

How to stop plotting particular bar value?

Find more posts tagged with

Comments

mwilliams

Hi mh10,

What is the cause of not plotting this bar? Is it a parameter or something you could use to filter the data available to the chart?

mh10

out of these 12 bar values one value is 0. And i don't want to plot this value 
 
I tried in y-series expression 
if (row[y_col] >0 ) 
row[col1] 
 
on chart this shows 11 bars...but on place of 12 bar it doesn't show anything...but its space is there with its related value on category axis. 
 
then i tried in x-axis/ category expression 
if(row[x_col] != "related name of this 12th bar") 
row[x_col] 
 
this show 'null' on category asix for that bar. 
 
I am looking to avoid plotting this bar on chart....not even null and blank space for this particular bar. 
 
 
 
Thank 
 
 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">Hi mh10, 
 
What is the cause of not plotting this bar? Is it a parameter or something you could use to filter the data available to the chart?</blockquote>

mwilliams

mh10,

In the chart editor, go to the select data tab, then click on the filter button at the bottom. Add a filter that is 'row[y-col] greater than 0'. I would assume that would get rid of that value all together. Let me know.

mh10

It worked as i expected....Thanks Michael 
 
 
 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">mh10, 
 
In the chart editor, go to the select data tab, then click on the filter button at the bottom. Add a filter that is 'row[y-col] greater than 0'. I would assume that would get rid of that value all together. Let me know.</blockquote>

mwilliams

mh10,

No problem.