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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Charts form drop down 2
Creating separate graphs for columns of data 1
Line Graph - Help 1
Automatically shift chart data range 4
Area chart dives to zero when data series stops 2
Database 1
Chart moves on plot area when adding a third month 2
Counting the number of date entries in a giving month 4

Back
Top