Thread: Charts
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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