Hi,
Trying for graphical representation to show a level depending on values.
e.g. I have a table and the values will vary from 1 to 50.
I have the textbox set up with conditional formatting using compare to other records so as to get the fill in bar chart effect.
Trouble is the bar is already extended some way in when the value is 1.
I would expect just the thinnest bar when 1 but is at least 2cm
I have set tried CF with ..
low number 1, high number 50
left as low & high and the data has 1, 25 ,50
they all start off with the 2cm extra but I would really like if value 1 at a glance to see that it is the lowest.
I could somehow hide using a rectangle or something else but this just seem wrong.
Any idea's. Is this the way is it or just me?
Trying for graphical representation to show a level depending on values.
e.g. I have a table and the values will vary from 1 to 50.
I have the textbox set up with conditional formatting using compare to other records so as to get the fill in bar chart effect.
Trouble is the bar is already extended some way in when the value is 1.
I would expect just the thinnest bar when 1 but is at least 2cm
I have set tried CF with ..
low number 1, high number 50
left as low & high and the data has 1, 25 ,50
they all start off with the 2cm extra but I would really like if value 1 at a glance to see that it is the lowest.
I could somehow hide using a rectangle or something else but this just seem wrong.
Any idea's. Is this the way is it or just me?