Charts

[Guest]

Hi,

Is it possible to eliminate cells without value (Say NA) while creating bar
charts?

eg jan Feb march
15 NA 22

so in Feb i want value as NA.(or the chart should not have feb data point)
this is a fixed chart and source data gets updated every month...

thanks in advance for your valuable time and advice..

Jithu

 

[Pete_UK]

If you arrange the data to be in columns going down, i.e.:

Jan 15
Feb 0
Mar 22

and used 0 for no value, then you could apply a custom filter for not
equal to zero to hide the row - it will not show on the graph.

Alternatively, leave the cell blank.

Hope this helps.

Pete