Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top