G
gibsol
I have a bar chart that differentiates between positive and negative numbers
e.g.
data 1 totals 7, data 2 totals 3 and is displayed starting where data 1
finished, totalling 10 on the Y axis, but shown in two different columns data
1 = 7 & data 2 =3, data set 3 is negative 2 starting where data 2 finished
i.e. displayed from point 8 on the Y axis going upto 10, What I am trying to
do is where a value is less than 1 (positive or negative) the data label to
show 0 and no column to show.
Hope that does not sound to mixed up !!.
e.g.
data 1 totals 7, data 2 totals 3 and is displayed starting where data 1
finished, totalling 10 on the Y axis, but shown in two different columns data
1 = 7 & data 2 =3, data set 3 is negative 2 starting where data 2 finished
i.e. displayed from point 8 on the Y axis going upto 10, What I am trying to
do is where a value is less than 1 (positive or negative) the data label to
show 0 and no column to show.
Hope that does not sound to mixed up !!.