Skip to Content
0
Former Member
Mar 06, 2009 at 10:33 AM

bar chart - a simple formatting problem

21 Views

hi,

i have created a bar chart for one single customer. That means on the chart i have just one bar (which is what i want). The bar is subdivided into 2 sections based on a 'yes' or 'no' value in another database field called .

in the chart expert in the 'show values' box, i have nothing; i set the drop down box to 'for all records'. In the 'show value(s)' box, i have 2 formulas that look something like this:

formula1: if field='yes' then 1 formula2: if field='no' then 1

in the chart i have set these to 'sum of formula1' & 'sum of formula2'.

the information being displayed on the bar sections is correct. however, if, lets say one sections sum is 0, a 0 is displayed on the chart. How can i get it that if the sum of formula1 (or formula2) is zero, then no value is displayed on the chart. (except for the values greater than 0) ?

thanks.

j