Charts
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
On Oct 1, 9:19 am, Jithu wrote:
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
|