ignore 0 values in the graph when the range with formula output is zero

[jayalaxmi]

Hi Team,

I am looking out for the solution to ignore 0 values in the graph when the range with formula output is zero(in bar graph).

Please find attach the screenshot. I dont want to chch and LBC in my chart as there are no values for it. Looking out for auto option.

And my range is

Any help is appreciated.

Thanks in advance.

Regards
Jaya

 

[rahulshewale1]

hii @jayalaxmi ,

See if is ok ?

i used dymanic range using offset and helper coloumns


Regard
Rahul shewale

 

[jayalaxmi]

Hey yes something of this kind but I already have formula in my GBS and KH area.

Can you help me with this file

 

[rahulshewale1]

Hii @jayalaxmi ,


PFA file,


See Service issue NZ Chart and sheet1 Support File.

Please use same techique all chart.